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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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 

Quasar

@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
Alteryx Certified Partner

Hi @Nouha 

 

Not the fanciest solution, but it works pretty well.

 

pic.PNG

 

Cheers,

Labels