Splitting Column

[nwatzlaf]

Hi there,

I have an Excel input that contains a member name and email all in one field. I am first trying to create a new column when the workflow hits the "<" character. 

Last Name, First Name  <Email

Then I am trying to re-write the name text as simply First Name Last Name.

I would love to create a workflow that has two distinct columns seen below.

Member Name                          Member Email

First Name Last Name              Email 

Any assistance is greatly appreciated.

Thanks!

Natalia

[Luke_C]

Hi @nwatzlaf 

Have you checked out the text to columns tool? You should be able to put < as the delimiter and have it split into 2 columns.

[geraldo]

@nwatzlaf 

An Workflow example

[nwatzlaf]

Hi @Luke_C 

After continued fumblings with text to columns I got that to work. Thanks!! That was my primary goal of the workflow. Adjusting the name would have been a bonus.

Thank you for your time,

Natalia

[nagakavyasri]

@nwatzlaf Try this: