AnsweredAssumed Answered

to

Question asked by alanftlim@gmail.com on Jan 24, 2018
Latest reply on Jan 24, 2018 by philmodjunk

I am trying separate a first and last name which is in the same field

eg

COLLIER, GREG

RICKERS, MARY ANN

ESPINET LOPEZ, JUAN MICHAEL

 

I want to have  everything in before the comma in a last name field and everything after the comma in a first name field.

I have tried left and right words but some names have a single name other people have double first or surnames.

Middle words using the comma as the starting word has also not worked.


Regards

 

 

Alan

Outcomes