Hi all,
I'm trying to figure out how to split a single line text field into two fields.
The single line field would contain a full name: Jon Doe
I need to split it into two columns sfirst name] ]last name].
Some fields may also include middle names, I would like those to be included in the last name column
Please advise
Hello,
regular expression actions are your friend here
Afterwards you need to grab both elements from your collection and save it to your columns.
Hope this helps.
Kind regards,
Enrico
Thank you so much!!! I had the regular expression but couldn't quite figure out what to do with the collection!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.