This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
hi,
I would like to transform
N11111 XXXX YYYY
N2222 XXX YYYYYYY
to
XXXX YYYY
XXX YYYYYYY
how can I best do that?
Solved! Go to Solution.
Hi @SylviaK ,
If the example data is representative of your real data - DON'T RegEx it:
Substring([Data],FindString([Data], " ")+1)
It finds the first SPACE and gets everything to the right of it.
Here's a video that walks you through this and other solutions:
Cheers,
Mark
@MarqueeCrew, the OG king of RegEx! Amazing what you can learn in less than 5 mins!
Thanks for the awesome video, @MarqueeCrew! I need to get back into my Alteryx practice and the way you make it look easy is really encouraging.
Plus, I'm super jealous of your mic set up - cool to have that behind the scenes look!
Thanks so much @MarqueeCrew ! I'm studying for my core exam and it's really helpful to have videos to watch someone use tools like this one. I'm more of a visual learner. 🙂
@MarqueeCrew: Thank you so much! Really helpful explanation of what to do and how the different functions work.