[CSV Export has extra commas]

Figured It out thanks

[CSV Export has extra commas]

Hi All,

I am trying to export a csv file from JasperSoft Studio in Eclipse, the problem is that each row has a different number of columns.

The first row has two columns. and the next two has twelve

i have pasted below part of the CSV file I am generating, my issue lies with the commas that i have pointed out in red below.

If anyone can help me figure out where in my java code or where in the xml code that I can limit the delimiters for the first row let me know.

Any input at all would help.

 

textInTitle , TextInTitle ,,,,,,

SometextInColumn,,,moretext,text,text,text,text

textInDetails,,,0.0%,100.0%,0.0%,21.5%,3.28%

textInDetails,,,100.0%,0.0%,0.0%,16.97%,3.28%

 

 

Thanks,

Patrick