Regex_Replace
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarqueeCrew, the OG king of RegEx! Amazing what you can learn in less than 5 mins!
Manager, Community ACE Program
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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. 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarqueeCrew: Thank you so much! Really helpful explanation of what to do and how the different functions work.
