Extract username from Email (without plus sign)

[tjamal1]

Hello,

I have a field in a table which has these types of emails in it.

Email

tariq.jamal@gmail.com

tariq.jamal+45@gmail.com

johnmackenzie@gmail.coom

I want to extract the first part only without + sign and domain

Expected Result (for above three records)

tariq.jamal 

tariq.jamal 

johnmackenzie

How can I do this in Alteryx Designer?

[atcodedog05 · Accepted solution]

Hi @tjamal1 

Here is how you can do it.

Workflow:

In ([\u\.]+).*@.* the ([\u\.]+) extracts string with letters and dot. \u stands for letters and \. stands for dot.

Hope this helps : )

[atcodedog05]

Hi @tjamal1 

Here is are some resources to learn more about Regex

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

https://community.alteryx.com/t5/Interactive-Lessons/Replacing-Data-with-RegEx/ta-p/441426 

Hope this helps : )

[tjamal1]

I checked this formula for 154 emails and it works as expected. (Y) 

Thank you so much @atcodedog05

[atcodedog05]

Happy to help : ) @tjamal1 

Cheers and have a nice day!