split column contain number and strings

[mhafizyi]

Hi 

I have this column

123549 GREEN

125447 YELLOW BLACK

566822 BLACK YELLOW GREEN

Which tools should I use to transform it into this column

123549	GREEN
125447	YELLOW BLACK
566822	BLACK YELLOW GREEN

Thanks.

[LordNeilLord · Accepted solution]

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 solution]

Hello,

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

[mhafizyi]

Thank you LordNeilLord and andreea_aurica14. 

[kapoorp]

I am trying to split the below column into 3 - one containing text and others containing numeric part i.e. Date

Trip

TRIP TO NYC 11/26-11/30

TRIP W/MANAGER 02/03-02/08

TRIP WITH COLLEAGUE 09/25-09/27

TRIP W/MANAGER 01/16-01/25/19

HOTEL STAY IN GEORGIA

TRIP WITH CEO 09/17-09/21

Output:

DEST	DT1	DT2
TRIP TO NYC	26-Nov	30-Nov
TRIP W/MANAGER	3-Feb	8-Feb
TRIP WITH COLLEAGUE	25-Sep	27-Sep
HOTEL STAY IN GEORGIA