CONVERTING XML FILE TO FLAT FILE.

[tekpr00]

Hi,

I am hoping someone will help here.

I have XML file that was ftp'd to me. I need to convert it into commma separated flat file.

This flat file is to be loaded via sqloadr into the database.

My question is how can I convert xml file into flat file and vice versa in a unix environment before loading it into oracle database table.

Thank you.

 

[ChrisHunt]

Maybe a question for forum426 ?

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

 

[taupirho]

If you need to convert xml to CSV you'll probably want to use something like xsl. If you have a copy of excel 2003 or later you could use this to read the xml file and then save same as a csv file.

It is also possible to sqlload an xml file directly into the database too.


In order to understand recursion, you must first understand recursion.