Splitting a field and populating two columns

  • 1 February 2017
  • 2 replies
  • 7 views

Badge +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


2 replies

Userlevel 4
Badge +12

Hello,

regular expression actions are your friend here

198183_pastedImage_2.png

Afterwards you need to grab both elements from your collection and save it to your columns.

198184_pastedImage_3.png

198185_pastedImage_4.png

Hope this helps.

Kind regards,

Enrico

Badge +8

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

Reply