I need clarification on what i am doing wrong here.
I have a field called Combined name that stores names from another database in the format [Surname, FirstName MiddleNames]
I am trying to extract them into separate fields SepSurname SepMiddleNames SepFirstName
Sometime the surnames are 2 or 3 words and sometime people have multiple middle names.
I have been using MiddleWords (Combined; "," 1) to try to get the SepFirstName but it keeps returning the Surname
For SepMiddleNames i was going to try MiddleWords (Combined; SepFirstName, 10)
For SepSurname was thinking of a script that would return all words left of the comma