Record parsing

  • Thread starter Thread starter Hal Pratt
  • Start date Start date
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)???
 
FirstName = Mid([FieldName], InStr([FieldName], ",") + 1)

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