LuttermJ
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by LuttermJ
-
After many frustrating hours, trying to solve the exact same problem ... I have a "simple" solution: Open the "properties" for your project (<abc>.jrxml)Select Jaspersoft StudioSelect ExportersSelect CSV ExporterChoose whether you want to make this change globally (i.e. Workspace), or only for the "Project", or only for the "File"In the "Record Delimiter" field enter "rn" (without quotes)I found that when entering "nr", as recommended by Jaspersoft ... then the .CSV file contains <LF><CR>, which is not properly interpreted/displayed by Windows ... causing the very long line without apparent breaks. Jon
-
csv format: how to get carriage returns at the end of the lines?
LuttermJ replied to angie.zhou's topic in Products
After many frustrating hours, trying to solve the exact same problem ... I have a "simple" solution: Open the "properties" for your project (<abc>.jrxml)Select Jaspersoft StudioSelect ExportersSelect CSV ExporterChoose whether you want to make this change globally (i.e. Workspace), or only for the "Project", or only for the "File"In the "Record Delimiter" field enter "rn" (without quotes)I found that when entering "nr", as recommended by Jaspersoft ... then the .CSV file contains <LF><CR>, which is not properly interpreted/displayed by Windows ... causing the very long line without apparent breaks. Jon
