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 HELP

rrahu07
8 - Asteroid

Can someone please help me get the desired output?

 

InputOutput
F2or0th-e0ta8xa8b0le3ye3a1r20-0880331
4 REPLIES 4

Hey @rrahu07 , not regex but you can use the Data Cleansing tool instead to remove all letters from the cell. It will give you the desired output. 

 

Capture.PNG

IraWatt
17 - Castor
17 - Castor

Hey @rrahu07,

Here is one way to do this:

IraWatt_0-1658520999738.png

The regex:

[\d-]

Matches with any dash or number creating a new row from it. I then use the summarize tool to bring it all back together.

 

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20... 

 

Any questions or issues please ask! 
Hope that Helps

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

rrahu07
8 - Asteroid

That was a good solution. I was trying to make it complicated for no reason. THANKS @michelle_mathews 

Emmanuel_G
13 - Pulsar

Hi @rrahu07 ,

 

One way to do this using regex,

Emmanuel_G_0-1658521211582.png

 

Labels