File Content Conversion

[#1]

Hi All,

I am doing a File - to - JDBC scenario. In this I am getting a CSV file from source.

What is the required information I have to ask the client to convert this flat file to an XML file using XI like file structure, lenths. what are all the other information required for this.

Could anybody please tell me what is csv file, how to convert it to xml.

If possible, please suggest screen shots.

Thanks in advance.

Regards,

Anu.

[sunil_singh13]

Hi Anu,

CSV means Comma separated values and "Not Comma delimated file".

there is difference between these two.

you can give "," as a field separator between two fields

you can give "nl"(new line) as a delimator value.

Well required info from client can be

what would be the separator for two Rows (It Won't be comma)

To Convert csv file to xml the links given by above Friends are useful.

reward Points if Helpful

Thanks

Sunil Singh