Hi, I am trying to use text to columns to parse this string: Smith, John To have just "John.Smith@alteryx.com" in a column. Does anyone know how to parse this? C

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

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

Custom Tools

Here is the updated workflow

Hope this helps : )

Here is how you can do it.

Workflow:

Hope this helps : )

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

@wonka1234 similar approach like @atcodedog05