Parse values at end of text field from Right to Left

[hellyars]

This is primarily a RegEx question.  FIELD_1 is start point.  The fields to the Left of FIELD_1 are the desired output.  

I know how to separate ITEM #  from TEXT and extend it down until the next ITEM #.  

How can I parse the dollar values from FIELD_1 and assign them to BUDGET, NEW_BUDGET, and CHANGE.   Reading FIELD_1 from RIGHT to LEFT.   The first value = CHANGE.  Two values = CHANGE and NEW_BUDGET.  Three values = CHANGE, NEW_BUDGET, and BUDGET.

FIELD_1	ITEM #	TEXT	BUDGET	NEW_BUDGET	CHANGE
1 Specialized Roubaix Pro 82000 82000	1	1 Specialized Roubaix Pro	0	82000	82000
Production increase 82000	1	Production increase	0	0	82000
2 Cervelo R5 742998 738798 -4200	2	2 Cervelo R5 742998 738798 -4200	742998	738798	-4200
New carbon seat post -4200	2	New carbon seat post -4200	0	0	-4200

[hellyars · Accepted solution]

I made some progress.  I used ReverseString to flip FIELD_1.  I then used the following RegEx expression to parse the values from the beginning text.  I then used ReverseString on the two RegexOut fields to return the text and values to their original values.  Now, I just need to parse the values from R to L and align with the CHANGE, NEW_BUDGET, and BUDGET fields.

(^.*?)\s([A-Za-z].*$)

[hellyars · Accepted solution]

Okay, I solved it.  The final step was to simply use a Text to Columns tool using \s as the delimiter and the output to 3 fields.  The 3 output fields exactly corresponded to CHANGE, NEW_BUDGET, and BUDGET.  I definitely made this harder than it needed to be.