Splitting a text field

[itskimharris]

Hi, 

I'm attempting to split a text field into two. While the split function is working, I want to remove the portion that I no longer need.

For example:
I want to split an email: myname@google.com and yourname@alteryx.com
I want the results to display only the portion following the "@" character (i.e. "google.com" and "alteryx.com").
I don't need the "myname" and "yourname" portions.

How can I achieve this?

Note: I'm okay if these split into two separate column fields (so that I can select the column I want). Currently, the output is populating under the same column.

[Jonathan-Sherman]

Hi @itskimharris,

You could achieve this with a text to columns tool using the standard configuration whilst changing the delimieter to an @ symbol.

Kind regards,

Jonathan

[messi007 · Accepted solution]

@itskimharris,

Please see below :

Attached the workflow,

Regrads,

[minhdvo]

I used 'Text to Column' to split a text column into multiple column.