Regex_Replace

[SylviaK]

hi, 

I would like to transform 

N11111 XXXX YYYY

N2222  XXX YYYYYYY

to 

XXXX YYYY

XXX YYYYYYY

how can I best do that?

[MarqueeCrew · Accepted 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

[bpatel]

Hi @SylviaK ,

you could also use text to columns.

hope this helps!

[TuvyL]

@MarqueeCrew, the OG king of RegEx! Amazing what you can learn in less than 5 mins!

[MaddieJ]

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!

[LaurenU]

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. 🙂

[SylviaK]

 @MarqueeCrew: Thank you so much! Really helpful explanation of what to do and how the different functions work.