Extract username from Email (without plus sign)

Hello,

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

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

johnmackenzie

How can I do this in Alteryx Designer?

Expression

Accepted answers

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 : )

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 : )

Here is are some resources to learn more about Regex

Hope this helps : )

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

Thank you so much @atcodedog05

Happy to help : ) @tjamal1

Cheers and have a nice day!