Record parsing

H

Hal Pratt

Have file with records with name field expressed as last name, first (i.e.,
Smith, John OR Jones Jr, Ron E.). How can I easily parse last names (char
left of comma) from first names (char right of comma)???
 
K

Ken Snell

FirstName = Mid([FieldName], InStr([FieldName], ",") + 1)

LastName = Left([FieldName], InStr([FieldName], ",") - 1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating first and last names when they are in the same cell 4
trim 3
Delete X characters from end of string 3
reformatting a name 2
Multiple records in table to display single records 7
Splitting a Field Question 2
Reversing name values in a field 4
Searching Text String 4

Top