.csv file windows/unix/mac format ?

[Zicks]

Hi,

 

I'm currently using jasperreport in a java application that export .csv files into .pdf using .jasper files.

 

I'm having a few issues with .csv file format.

If you try to open a csv file with an editor like notepad++ you can see that "End of line" characters are different whether the file is windows (EoL is 'CRLF') or unix formatted (EoL is 'LF').

 

The wierd thing is : when I use jasperreports inside my java application, csv file (windows format) won't work and jasper says "Unknown column name X" (even though 'X' is the correct field).

But unix format csv file works just fine.

 

Even wierder, when I try with iReports, it works whether the csv file are windows or linux or whatever format.

 

Is there a way to convert a file from windows to unix format with just java code, as I can't convert every csv file manually.

 

Thanks in advance.

[lucianc]

Follow-up here.

 

Regards,

Lucian