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.
Solved! Go to 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 😀👍
Works perfectly, thanks for the quick reply!