Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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