Alteryx designer Discussions

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.

regex clean column

6 - 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 




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



12 - Quasar

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



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

6 - Meteoroid

thank you tons, it works :)

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Nouha 


Not the fanciest solution, but it works pretty well.