CSVs - long strings are moving to next line

[2004 IR Help]

By: sst_marvin - sst_marvin

CSVs - long strings are moving to next line

2004-12-09 23:05

Hi,

 

Im producing reports as .csv files with iReport and am encountering problems with some strings (usually the lengthy ones), where somewhere along the string, it would break off and move to the next line.

 

As an example, a correct .csv would be:

title,name,description,age

Mr,Bart Simpson,short description,10

Mr,Homer Simpson,long description. this is a very long description,30

 

But, iReport sometimes produces:

title,name,description,age

Mr,Bart Simpson,short description,10

Mr,Homer Simpson,long description. this is a,30

,,very long description,

 

This only happens rarely, but everyone knows how this ruins the csv file. Note the two commas before the string that broke off - the string is still being placed in the right 'column' so to speak.

 

FYI, I encountered problems before where the row being produced would go:

title,name,description,age

Mr,Bart Simpson,short description,10

Mr,Homer Simpson,long description. this is a

very long description,30

 

See how the remainder of the entire row was brought to the next line - a problem fixed by making sure I replaced all return characters with spaces. But I have no idea what's causing my current problem.

 

Any help is appreciated,

Marv

 

 

 

 

By: sst_marvin - sst_marvin

RE: CSVs - long strings are moving to next line

2004-12-12 16:47

i changed all my font sizes to 1. this seems to have fixed the problem (well i received no bad rows out of 5500 rows)