Thanks so much for your answer!
Seeing the configuration option via CATALINA_OPTS has opened my eyes.
In my case, testing the configuration option you mentioned does not generate the file with the chosen separator [#], it continues to generate it with the separator [,].
However, searching through the Pentaho Reporting project:
[Line 39] @ https://github.com/pentaho/pentaho-reporting/blob/master/engine/core/src/main/java/org/pentaho/reporting/engine/classic/core/modules/output/table/csv/CSVTableModule.java
I have found the necessary configuration option:
CATALINA_OPTS="$CATALINA_OPTS -Dorg.pentaho.reporting.engine.classic.core.modules.output.table.csv.Separator=#"
export CATALINA_OPTS
Now it's working as expected.
Thank you very much for your help.
------------------------------
Javier Camara
Project Manager
Agencia Digital de Andalucia - Junta de Andalucia
------------------------------
Original Message:
Sent: 03-15-2023 01:24
From: Stephen Shipe
Subject: Pentaho 9.3 - Pentaho Server - CSV Report - Select custom separator
Yes, you can specify the separator character for CSV output in Pentaho Report Designer by setting a system property in the Pentaho Server configuration file.
The property you need to set is:
-Dorg.pentaho.reporting.engine.classic.core.modules.output.table.base.DefaultTableWriteHandler.SEPARATOR=|
Replace the "|" character with the separator character you want to use.
To set this property, you can edit the Pentaho Server configuration file, which is typically located at /biserver-ce/tomcat/bin/catalina.sh (for Linux/Unix) or /biserver-ce/tomcat/bin/catalina.bat (for Windows). Add the above property to the CATALINA_OPTS environment variable. For example:
CATALINA_OPTS="$CATALINA_OPTS -Dorg.pentaho.reporting.engine.classic.core.modules.output.table.base.DefaultTableWriteHandler.SEPARATOR=|"
export CATALINA_OPTS
After setting this property, restart the Pentaho Server for the changes to take effect.
Once you've set the property, any CSV output generated by the Pentaho Report Designer will use the specified separator character instead of the default comma.
------------------------------
Stephen Shipe
Chief Executive Officer
Knox Lumber
Original Message:
Sent: 03-14-2023 18:01
From: Javier Camara
Subject: Pentaho 9.3 - Pentaho Server - CSV Report - Select custom separator
Hello everyone.
This is my first message in the community. Please excuse me if I make any rookie mistakes.
I am trying to generate reports, designed with Report Designer in Pentaho Server, in CSV format.
The problem is that the default separator is the comma character, but some fields' texts contain that character and I need to be able to set a different character as the field separator.
I am looking for a configuration file where I can specify it, but I cannot find it on the server.
Do you know if there is any configuration option to choose the separator character?
Best regards and thank you very much.
------------------------------
Javier Camara
Project Manager
Agencia Digital de Andalucia - Junta de Andalucia
------------------------------