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.
@Emil_Kos Thank you. This is more efficient/elegant than the multiple filter path I went down.
Happy to help!
Hi @hellyars
Here's my efficient approach...
