CSV export without double quote (")

Hi all,

I want so use birt to create CSV data-files (Run -> view report -> export data). Later the csv files should be created automatically. Unfortunately birt inserts quotations marks into the csv file. The result looks like: a;"bbbbbb";"ccccc". But what I want is a result that looks like a;bbbbbb;ccccc.

Is it further on possible to eliminate the column headings from the csv file?

regards,
Garvin Riensche

Find more posts tagged with

Comments

SailRCG

Hi Garvin,

To remove Column Headers from your report when you output to CSV, you can use a visiibility control that will evaluate the report outuput type. When the output type is csv, or xls for example... you can make the header visible false.

I'll need to think about the " " marks... I know there is an issue with adding strange characters when you have trailing whitespace in a field... It could be possible BIRT is adding the " " marks as a result of how the csv emitter is written.

garvin

Hi, 
 
<blockquote class='ipsBlockquote' data-author="SailRCG">
To remove Column Headers from your report when you output to CSV, you can use a visiibility control that will evaluate the report outuput type. When the output type is csv, or xls for example... you can make the header visible false. </blockquote>
Whats is this "visibility control" ? Is it an external tool that has to used or is there an option in birt that turns the creation of the header off? I know I could use java to get rid of the header after the generation of the report but I would prefer a solution that won't create the header. 
 
<blockquote class='ipsBlockquote' data-author="SailRCG">
I'll need to think about the " " marks... I know there is an issue with adding strange characters when you have trailing whitespace in a field... It could be possible BIRT is adding the " " marks as a result of how the csv emitter is written.</blockquote>
So, it seems like it is not possible to tell birt not to insert " ". 
 
regards, 
Garvin