Splitting a field and populating two columns

+8

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 [first name] [last name].

Some fields may also include middle names, I would like those to be included in the last name column

Please advise

+12

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

+8

Thank you so much!!! I had the regular expression but couldn't quite figure out what to do with the collection!!

Sign up