Parse Field from Right to Left

[hellyars]

The values for three fields are trapped from Right to Left in FIELD_1.  How can I parse FIELD_1 across the fields ONE, TWO and THREE

FIELD_1	ONE	TWO	THREE
82000 82000	0	82000	82000
20851 16551 -4300	20851	16551	-4300
-4200	0	0	-4200

[Emil_Kos]

Hi @hellyars,

If the delimiter is space you can use simple text to columns.

If this was helpful please mark as an answer!

[Emil_Kos]

Hi @hellyars,

Thank you for marking my post as an answer!

Good Luck!

[hellyars]

@Emil_Kos   Yeah, that's where I got stuck.  Notice that the Text to Columns tool does not place the values in the right order.  The best example to examine is the last row of -4200.  The -4200 should be assigned to THREE not ONE.  The Text to Columns tool places it in ONE. 

[Emil_Kos · Accepted solution]

Hi @hellyars,

I missed that. It will work now:

[hellyars]

@Emil_Kos Thank you.  This is more efficient/elegant than the multiple filter path I went down. 

[Emil_Kos]

Hi @hellyars,

Happy to help!

[HomesickSurfer]

Hi @hellyars 

Here's my efficient approach...