Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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