Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Parse Text String Not Working

Hello All,

I have a text string in a file (comma-separated) with some blanks in it. For instance, please see the below:

,Ali,stadter,manisha.123+leonard@XX.com,700398,6472208976,9/5/1989,52.2,0,1356.16,1042.33,52.16,22.12,75.49,73.39,30.98,75.49,142.83,,,,,0,5

I tried using the BSFN's "Parse Text Strings", however, the BSFN is not recognizing the blank values, for instance, if I pass the segment number as zero the return value should be "blank", however, it returns the next segment value as it is not considering the blank values.

Kindly advise.

Appreciate your help.

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