Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Text to Columns

amanda
6 - Meteoroid

Hello. I am trying to create a new field of just the data after the " at " for records such as:

 

Student at Arizona State University
IT Specialist at Other
Teaching Assistant at University of Maine at Augusta
Security Professional at Raytheon
Regional Manager at Mcadc
Assistant Manager at Chilis

 

So I need instead a new field of:

 

Arizona State University
Other
University of Maine at Augusta
Raytheon
Mcadc
Chilis

 

I have tried to text to columns as well as replace the at and trim the at, but still is not working correctly. I'm sure it is something easy I am missing. Any feedback would be much appreciated. 

 

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @amanda 

 

Use Regex tool in parse configuration like below.

atcodedog05_0-1603382083906.png

Output:

atcodedog05_1-1603382101230.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

amanda
6 - Meteoroid

Works perfectly, thanks for the quick reply!

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @amanda 

 

Cheers and Happy Analyzing 😀

Emil_Kos
17 - Castor
17 - Castor

Hi @amanda,

 

Please find attached an alternative solution.

 

Emil_Kos_0-1603382431748.png

 

 

Good luck!

Labels