Alteryx Designer Desktop Discussions

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

Splitting Emailid

Gurpriya
5 - Atom

Hi all,

 
I want to split the email in username and domain. how can we do this in alteryx.I am attaching sample data.
 
Thanks in advance
5 REPLIES 5
MarqueeCrew
20 - Arcturus
20 - Arcturus

The quickest way is to use a Text to columns tool and set the delimiter as:  @

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
bharti_dalal
10 - Fireball

Hi @Gurpriya,

 

Alteryx can solve most your problems. Here I am attaching Solution. Hope that helps.Screenshot (154).png

LordNeilLord
15 - Aurora

Hey @Gurpriya

 

Text to columns would be the easiest:

 

emailsplit.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

LordNeilLord
15 - Aurora

Wow! I was slow on that one

bharti_dalal
10 - Fireball

@MarqueeCrew Played a witty game! Lol

Labels