Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Extract username from Email (without plus sign)

tjamal1
8 - Asteroid

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?

 

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @tjamal1 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1648372776696.png

 

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

 

Hope this helps : )

tjamal1
8 - Asteroid

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

 

Thank you so much @atcodedog05

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @tjamal1 

Cheers and have a nice day!

Labels