I have the following data for example. There are eight data fields; ID, name, race, gender, age (dob), SSN, phone and address. They always appear in the same order.
1 smith, mary Black/African American Female 37 (12/08/1977) *****1234 267-111-2222 1111 Main Street, Perkasie PA, 19144
Is there a way using regular expressions to parse this? The ID field is numeric. I know all the possible values for race and gender. The SSN will have ***** with only the last 4 visible.