CSV Export has extra commas

Posted on June 20, 2017 at 1:26pm

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

pbohman

Joined: Jun 20 2017 - 1:00pm

Last seen: 6 years 3 months ago

2 Answers:

Posted on June 20, 2017 at 4:22pm

That's the csv specs. If you want to delete those commas, you can just use "sed" command from bash shell to delete them.

hozawa

190849

Joined: Apr 24 2010 - 4:31pm

Last seen: 4 years 3 months ago

Posted on June 21, 2017 at 9:41am

Figured It out thanks

pbohman

Joined: Jun 20 2017 - 1:00pm

Last seen: 6 years 3 months ago