Results 1 to 3 of 3

Thread: Reading from Flat file (XML) and adding substrings as data to table

  1. #1

    Reading from Flat file (XML) and adding substrings as data to table

    Hi everyone ,

    I need help.I want to use an UBE to read an XML as a flat file , and by using Fetch next Line from flat file , cut a substring between the <MS1:MsgId> to </MS1:MsgId> for example , and store it in a custom table , already built to match the type of the data we are going to extract from the flat file. Thing is , what would be the most effective way to check in each line if there is the data we are looking for and how to make the loop for searching the entire XML with 40 columns and unknown incoming row.

    Thanks in advance ,
    Nick

  2. #2
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,355
    Have a play around with BSFN B74XML01

    There is a module in there called XML Get XML Value by Tag Name G74. Also N7090070
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  3. #3
    Thanks a lot John ,

    the project was put on pause until February , so i will have a look at the BSFN you suggested ! Hope it works out!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.