Excel Exporter for CSV - Data is getting exported with quotes

0
Hi All, I am trying to use Excel Exporter module to export CSV data. I see that Column values(String) are getting exported with Double quotes. Ex: "Value1”,"Value2” Is there any mechanism where we can remove these quotes in the export? I did tried the flat file export module. problem here is the export setting we need to make every time in all environments manually. It doesnot have import and export templates functionality. So trying to see Excel Importer module. But I am stuck with this double quotes. Any work around for this? Thanks and regards, Nirmal Kumar
asked
1 answers
0

This appears to be hardcoded functionality in the Excel Exporter module.

If you felt comfortable changing Java code, you could fork the module, change the default quote character from the constant to an empty character, and see if that gives you the functionality you require.

https://github.com/mendix/ExcelExporter/blob/1fd4737b665e2c63db0d4542d0ca79c081d05b90/javasource/xlsreport/report/export/ExportCSV.java#L51

Alternatively, you could put a request in the ideas forum to make this functionality configurable.

answered