AnsweredAssumed Answered

Separating name fields

Question asked by alanftlim@gmail.com on Aug 15, 2018
Latest reply on Aug 16, 2018 by philmodjunk


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

 

Regards

Alan 

Outcomes