cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Splitting a field and populating two columns

Jump to solution

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

Tags (2)
0 Kudos
Reply
2 Replies
Workflow Hero

Re: Splitting a field and populating two columns

Jump to solution

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

Reply
Workflow Hero

Re: Splitting a field and populating two columns

Jump to solution

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

0 Kudos
Reply