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