AnsweredAssumed Answered

Extracting text from a field.

Question asked by paulatkins on Oct 22, 2012
Latest reply on Nov 5, 2017 by besjes

Hi,

 

I have a name field supplied by a school in this format:

 

CAFFIN-HOUGHTON, Eleanor

(last name comma firstname)

 

I need a LastName field and a FirstName field from the data.

 

I have used LeftWords and RightWords, but it does not handle the hyphenated names and I have plenty of both first and last names that are hypenated. Can I extract the text to the left and right of the comma?

 

Thank you,

 

Paul

Outcomes