I am trying separate a first and last name which is in the same field
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.