How to convert *.txt to *.xml format
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