Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

I am trying to parse the username from an email.

Til4006
5 - Atom

Hi,

 

I am trying to parse the username from an email.

 

Example: Leona@gmail.com

 

Outcome: Leona

 

Which expression should I use?

5 REPLIES 5
binuacs
21 - Polaris

@Til4006 one way of doing this

image.png

rzdodson
12 - Quasar

@Til4006 another way should you want to go the Regex route.

 

1 - Solution.png

ishan_dania
5 - Atom

.

grazitti_sapna
17 - Castor

 Hi @Til4006
One More way of doing this .You can Refer attached workflow
Thanks

Sapna Gupta
Lakshya_05
8 - Asteroid

Hello,

Kindly use the regex tool in parse method and then use the following expression to parse the mail in desired format.

"(\w+)\@"

 

Regards,

Lakshya

Labels
Top Solution Authors