Profound Logic Forums

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

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

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

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.

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

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