Wrong parsing of delimited text file
I have a pipe delimited string such as ABC||123
As you can see the 2nd value is empty, I tried using all the parsing bsfns in JDE but it looks like it skips the 2nd value. I expect to get back NULL or empty
So here's what I expect
Index Value
0 ABC
1 NULL or empty
2 123
But right now this is what I got which is WRONG
Index Value
0 ABC
1 123
Do you have any ideas?
Thanks
JDE 9.1