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