How can I separate the amount from the text using regex?

[RichardAlt]

Hello guys,

I'm quite new using regex in alteryx and I don't know what combinations of regex should I use.

This is my sample data, I need to separate this from text and the amount

NONPAR FOREIGN(OFFSHORE)
NONPAR FOREIGN(OFFSHORE) 3,123.00 15,123.57 6,123.57 43,123.83
NONPAR LOCAL(ONSHORE)
NONPAR LOCAL(ONSHORE) 144,123.23 404,123.09 511,123.87 1,123,225.48
PAR 5
PAR 5 3,123,865.74 15,123,000.83 13,123,107.99 19,123,805.31
PAR AFTER 2005
PAR AFTER 2005 .00 .00 .00 4,123,123.85
PAR BEFORE 2005
PAR BEFORE 2005 .00 .00 .00 1,123,861.12
PAR JH
PAR JH .00 .00 .00 123,542.83
TotalOutstanding: 3,631,123.97 15,123,411.49 14,123,962.43 26,406,123.32

My desired output is something like this. Disregard the strike.

NONPAR FOREIGN(OFFSHORE)
NONPAR FOREIGN(OFFSHORE)	3,123.00	15,123.57	6,123.57	43,123.83
NONPAR LOCAL(ONSHORE)
NONPAR LOCAL(ONSHORE)	144,123.23	404,123.09	511,123.87	1,123,225.48
PAR 5
PAR 5	3,123,865.74	15,123,000.83	13,123,107.99	19,123,805.31
PAR AFTER 2005
PAR AFTER 2005	0	0	0	4,123,123.85
PAR BEFORE 2005
PAR BEFORE 2005	0	0	0	1,123,861.02
PAR JH
PAR JH	0	0	0	123,542.83
TotalOutstanding:	3,631,123.97	15,123,411.49	14,123,962.43	26,406,123.32

This is my output and workflow used.

I've attached my sample workflow and source file please help.

[fmvizcaino · Accepted solution]

Hi @RichardAlt ,

I'm using two regex tools to accomplish the desired result. 1st to separate the text and the other to dynamically separate the numbers.

Best,

Fernando Vizcaino

[RichardAlt]

@fmvizcaino  Thank you! It's working.