Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Wrong parsing of delimited text file

edited Feb 18, 2016 12:59PM in Design Tools & Output Technologies - JDE1 (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center