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
Hi @hellyars,
I missed that. It will work now:
If the delimiter is space you can use simple text to columns.
If this was helpful please mark as an answer!
Thank you for marking my post as an answer!
Good Luck!
@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.
Hi @hellyars
Here's my efficient approach...
