Hello Dojo,
I have a scheduler task to send out an email of a Dashboard report with the CSV option enabled. There are values in the table that have values greater than 1000. Those values, when viewed in Excel, are being interpreted as decimal values, so 12,345 is showing up as 12 because the decimal part is being removed.
So is there a configuration that can be done to remove the comma from the CSV export?
Hi Gabriel,
This depends on the locale settings of your system and office package. In the Regional tab of the dataminer cube settings, you can change the "CSV separator to match the Regional settings of your system. By default, this is "Windows Culture", but you can explicitly change it to comma, semicolon, or tab. 
Hi Gabriel,
The CSV report sent with the email includes the display values rather than the raw data. To address the issue with numeric formatting (e.g., commas in values like 12,345 being misinterpreted), you can modify the display format of the values.
Hi Gabriel, hope you're good! I have read your question and the anwser above, i think you can change in the setting of excel app hot to handles decimal number and change it to interpret with a "." instead of "," that way your number 12,345 will be read as you want, and 12.345 will be a decimal number.
here is the link to microsoft documentation: Change the character used to separate thousands or decimals - Microsoft Support
Hello Joao, thank you for that information. So is there no way for Dataminer to export the data using the locale settings of the server or to change which separator is used for these numbers? It has to be changed in the Excel app?
From what I understand of the case, the problem is not with the dataminer but with the way Excel handles such data.
Hello Michiel, the issue is not the delimiter, it is using the semicolon separator and the CSV is being parsed correctly when it comes to the columns. The issue is one of the columns has a comma in it to show more than 1000 I.E. 12,345 instead of 12.345 or 12 345. This is causing excel to think 12,345 is a decimal and only showing 12.