Jump to content
Changes to the Jaspersoft community edition download ×

CSVs - long strings are moving to next line


2004 IR Help

Recommended Posts

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)

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...