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 |
Solved! Go to Solution.
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 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 Thank you. This is more efficient/elegant than the multiple filter path I went down.