Text to Columns

[amanda]

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. 

[atcodedog05 · Accepted solution]

Hi @amanda 

Use Regex tool in parse configuration like below.

Output:

Hope this helps 🙂

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

[amanda]

Works perfectly, thanks for the quick reply!

[atcodedog05]

Happy to help 🙂 @amanda 

Cheers and Happy Analyzing 😀

[Emil_Kos]

Hi @amanda,

Please find attached an alternative solution.

Good luck!