split column contain number and strings

Question

Hi

I have this column

123549 GREEN125447 YELLOW BLACK

566822 BLACK YELLOW GREEN

Which tools should I use to transform it into this column

123549GREEN125447 YELLOW BLACK566822 BLACK YELLOW GREEN

Thanks.

LordNeilLord · Accepted Answer

Hey @mhafizyi

In the regex tool (in parse mode) try this: (\d*)\s(.*)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

andreea_aurica14 · Accepted Answer

Hello,

You can use Text to column tool to split into 2 columns and a Select tool to uncheck first field.