How to remove double quotes from a string when exporting data in csv

Posted on March 18, 2022 at 3:13am

iReport 5.6.0

I am generating a report output in CSV using iReports but the string has double quotes at the start and end of the string for example:-

"1,2339,195,9000999,114"
"1,2339,195,9000999,5605"

How can i remove the double quotes when generating the output in csv?

Thanks

Satya

 

iReport Designer
satyajitsinhaext's picture
satyajitsinhaext
31
Joined: Feb 23 2022 - 2:29am
Last seen: 1 year 6 months ago

2 Answers:

Posted on March 18, 2022 at 8:29am

You can use the property net.sf.jasperreports.export.csv.field.enclosure

jgust's picture
jgust
6541
Joined: Jun 10 2010 - 6:39am
Last seen: 10 hours 18 min ago
Posted on March 18, 2022 at 12:08pm

Hi,

Thanks for responding to my query.

I am using iReport Designer. The double quotes are at the start and end of the string and not in each specific field. I assume the above parameter is at field level.

I tried adding it but the output was still the same. My intention is to remove the double quotes from the output string in the csv output file.

Thanks

Satya

satyajitsinhaext's picture
satyajitsinhaext
31
Joined: Feb 23 2022 - 2:29am
Last seen: 1 year 6 months ago
Feedback
randomness