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 [first name] [last name].
Some fields may also include middle names, I would like those to be included in the last name column
Solved! Go to Solution.
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.