CSV format data export issue - first column data contains a comma

[rr9876r]

Hi, 

I have designed a simple report in Jaspersoft Studio 6.4.2 version. The report works fine as expected and encounter an issue when saving/exporting data into CSV format if the column data contains a comma  and not enclosed the data value within double quotes. It is causing an issue when sending the CSV data file to another party because the number of cloumns in the record layout are different from other records in the file.  

For example, the report displays the like 

Title                             User     ===> column header
System, Admin          John, Doe
DBA                         Smith, Joe

When this exported into CSV format  and will be looks like this

Title,User
System,Admin,"John, Doe"
DBA,"Smith, Joe"

 

In the first line, the System, Admin is not within double quotes. This results the first line with with two commans and 2nd line with one comma. This is causing an issue when remapping CSV data in Excel and the data is not aligned correctlry. I can trim the comma from column data value but we wanted it. 

Any suggestions please

Thanks 
Ram

 

[hozawa]

So, why not just surround the text with quotes?

Quotes can be inserted by setting the following property to true

net.sf.jasperreports.export.csv.force.field.enclosure