Parsing Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to divide text from one field into two separate ones. The text is in
the format "Tom and Susan" in the field MailName. I want it to be in
primaryFN "Tom" secondaryFN "Susan"

Essentially I want to cut the fields after the space after the word "and"

Any ideas?
 
I want to divide text from one field into two separate ones. The text is in
the format "Tom and Susan" in the field MailName. I want it to be in
primaryFN "Tom" secondaryFN "Susan"

Essentially I want to cut the fields after the space after the word "and"

Any ideas?
Click to expand...

PrimaryFN = Left([MailName],InStr([MailName]," and ")-1)
SecondaryFN= Mid([MailName],InStr([MailName]," and ")+5)
 
Back
Top