community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

regex clean column

Meteoroid

Hello everyone,

 

I am very new to regex and i can't seem to make it work for my issue, but i think it might be the right solution.

 

I have a column with image sizes that look like this 

 

Capture.PNG

 

and i would like the end result to be just a column with the sizes as so "320x50" , "1200x250" no matter if the sizes are 

 

I put the file sample in :)

 

if there is a way to do it without regex its good too

 

thank you so much for your help

 

Nouha 

Bolide

@Nouha Probably a simpler way to do this in one expression, but parsing it into two groups using

 

(\d+)(?:\D)(\d+)

and then putting the first and second marked groups back together seems to work just fine based on your sample.

Meteoroid

thank you tons, it works :)

Alteryx Certified Partner

Hi @Nouha 

 

Not the fanciest solution, but it works pretty well.

 

pic.PNG

 

Cheers,

Labels