Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

B0500690 ParseTextString skip the NULL column/field

edited Nov 8, 2019 3:54PM in Design Tools & Output Technologies - JDE1 (MOSC) 1 commentAnswered ✓

writing a simple UBE to read the txt file ( with ; as delimiter ).  But some of the column/field ( separated by ;  like CSV file ) may or may not NULL. The B0500690 skip field if the field is NULL.

005    Fetch Next Line from Flat File

           PO szImportFilename_AFTLPATH -> BF szFlatFileName

           VA rpt_iGenericLong_GENLNG <> BF idFilePtr

           VA rpt_szFileInputString_PRSTR <- BF szFlatFileRecord

           "1024" -> BF mnRecordLength

0006    If VA rpt_iGenericLong_GENLNG is not equal to <Null>

0007       Parse Text String

              VA rpt_szFileInputString_PRSTR -> BF szInputText

              VA rpt_szWorkString1_DS40 <- BF szOutputObjectSegment

               2 -> BF mnSegmentNumber

              ';' -> BF cDelimiter

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