Conversion Issue excel to csv

[shahjapan]

Hello,

I have converted a xls file to csv one using Office UTF-8 encoding.

but when i use that file with my program using csv reader I can not get the correct output because in my excel file I have some columns (address like) having multiple line (ctrl+enter),

so when I am using it , it generates errors.

so solution may reside to convert it into a better csv having multiline as a single element but how any solution ?


thanks

[bvdet]

If you could give us a sample of the actual csv file, we may be able to figure out a way to parse it.

[bartonc]

I notice that the OP has posted the same question in the Java Forum: Either multi lingual or semi lost.... We'll see...