BI Publisher (MOSC)

MOSC Banner

How to convert *.txt to *.xml format

edited Aug 6, 2010 11:29AM in BI Publisher (MOSC) 4 commentsAnswered
 Hello BI Community,

I need a help with converting  (*.txt) format (*.xml) format automatically. How can we do that?

convert from:

File-A: TEST1,30-JUL-10,1,1000  (or comma-delimited)

File-B: TEST1 30-JUL-10 1 1000  (tab separated)

converted to:

  <?xml version="1.0" encoding="WINDOWS-1252" ?>
- <VENDOR_REPORT>
  <VENDOR_NAME>TEST1</VENDOR_NAME>
  <PAYMENT_DATE>30-JUL-10</PAYMENT_DATE>
  <VENDOR_NUMBER>1</VENDOR_NUMBER>
  <PAYMENT_AMOUNT>1000</PAYMENT_AMOUNT>
  </VENDOR_REPORT>

Your help is appreciated.
Thanks,
Oracle User

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