Wrong Decimal separator in csv export in German environment

[dieter]

Hello,

we use the csv export option for grids. Unfortunately the numeric data is separated by a dot. Excel interprets this not correctly. Our German excel expects a comma as a decimal separator.
E.g.:
The export delivers: "3493.30"
But we need: "3493,30"

Is there a possibility to adjust the separator?

Thank you,
Dieter

[Scott Klement]

Here's some information about how you can control the separator:
http://www.profoundlogic.com/docs/displ ... +Separator

[dieter]

Thank you Scott.
But i think there is a misunderstanding. I tried this by typing
pui["csv separator"] = ","; in my start.html.
But the effect is that the separator of the fields changes from semicolon to comma. The separator of the fields in the csv-file is not my problem. The problem is the decimal-separator of the numeric fields in the csv-file. (I don't know if "decimal-separator" is the correct term in English).

In my exported csv-files all fields are enclosed in quotation marks. Each field is separated from the next field by a semicolon. This is fine.

This is the actual export:
"FK 079185";"3493.30";"S"
"FK 079185";"3493.30";"H"

This should be the export:
"FK 079185";"3493,30";"S"
"FK 079185";"3493,30";"H"

Thanks,
Dieter

[Scott Klement]

I gave it a try and had the same results... the CSV export option is ignoring the job's decimal format. I'll see if I can fix it.

[Scott Klement]

This problem is now fixed on our development box, and the fix will be included in the next release of Profound UI.

[dieter]

Thank you. We can wait for the next release.
Dieter