Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regex_Replace

SylviaK
8 - Asteroid

hi, 

 

I would like to transform 

 

N11111 XXXX YYYY

N2222  XXX YYYYYYY

 

to 

XXXX YYYY

XXX YYYYYYY

 

how can I best do that?

 

 

6 REPLIES 6
MarqueeCrew
20 - Arcturus
20 - Arcturus

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 restart. Order shall return.
Please Subscribe to my youTube channel.
bpatel
Alteryx
Alteryx

Hi @SylviaK ,

 

you could also use text to columns.

 

hope this helps!

bpatel_0-1592930975304.png

 

TuvyL
Alteryx Alumni (Retired)

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

Tuvy Le
Manager, Community ACE Program
MaddieJ
Alteryx Alumni (Retired)

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
Alteryx Alumni (Retired)

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
8 - Asteroid

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

Labels