Text to columns, Parse this string to email only: Smith, John <John.Smith@alteryx.com>.

[wonka1234]

Hi,

I am trying to use text to columns to parse this string: Smith, John <John.Smith@alteryx.com>

To have just "John.Smith@alteryx.com" in a column.

Does anyone know how to parse this?  C

[atcodedog05]

Hi @wonka1234 

Here is how you can do it.

Workflow:

Hope this helps : )

[wonka1234]

@atcodedog05  Thanks! but how do I get just the "Smith, John" part? 

[atcodedog05]

Hi @wonka1234 

Here is how you can do it.

Workflow:

Hope this helps : )

[wonka1234]

@atcodedog05  thank you! i know this is bad of me to ask, but how about "John Smith" lol. 

If you want me to create a new question for that I will.

[atcodedog05 · Accepted solution]

Hi @wonka1234 

Here is the updated workflow

Hope this helps : )

[binu_acs]

@wonka1234 similar approach like @atcodedog05 

[atcodedog05]

Happy to help : ) @wonka1234 

Cheers and have a nice day!