Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Regex_Replace

Highlighted
6 - Meteoroid

hi, 

 

I would like to transform 

 

N11111 XXXX YYYY

N2222  XXX YYYYYYY

 

to 

XXXX YYYY

XXX YYYYYYY

 

how can I best do that?

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Alteryx
Alteryx

Hi @SylviaK ,

 

you could also use text to columns.

 

hope this helps!

bpatel_0-1592930975304.png

 

Highlighted
Alteryx Community Team
Alteryx Community Team

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

Tuvy Le
Manager, Community ACE Program
Highlighted
Alteryx Community Team
Alteryx Community Team

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!

Highlighted
Alteryx Community Team
Alteryx Community Team

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.

Highlighted
6 - Meteoroid

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

Labels