Mysterious ' " ' showing up... Bug or Feature

[rsilverns.sympatico.ca]

I have a report being exported as a CSV file which is behaving strangely. One of my fields is having " placed around the numeric value when a format is applied to it.

 

My data row consists of...

 

NAME | ACCT DESCRIPTION | ACCT VALUE | ACCT NOTES

 

where all values are Strings, except ACCT VALUE which is a Big Decimal.

 

When I apply no formatting the value prints fine.. e.g. 1152.42, however when I try to introduce a thousand's seperator ',' the problem is encounterd..

 

1152.42 becomes "1,152.42" rather than 1,152.42 (the quotes are showing up in export file). Is this some feature of CSV exporter related to the width of my fields in the report file, or is it a bug?

 

Anyone with input please feel free to post.

 

Thx,

Robin

Post edited by: rsilver@bfm.bm, at: 2006/12/08 18:19

[joeycn]

Comma(,) is the delimitation of the fields in csv files,

so the quotation mark means that this comma is just a comma. :)

[rsilverns.sympatico.ca]

Ahh good point... but whereas my seperation character has been switched to be a "|" it still surrounds the commas with quotes?

 

Edit: After looking at the source code, it appears that they assume all commas to be the delimeter even if the delimiter is switched. Will issue a bug on this one.

 

Thx,

Rob

Post edited by: rsilver@bfm.bm, at: 2006/12/11 12:17

[szaharia]

Hi,

 

The problem you observed was solved. All separator chars are now treated equally, and if you have some data fields containing one of the given separators, you'd better choose another one as field separator. Otherwise, the entire field value will be still quoted.

Sources were committed on http://scm.jasperforge.org/svn/repos/jasperreports

 

Best regards,

sanda