CSV export changes the decimal delimiter from comma(,) to dot(.)

[Sergio26]

Hello all,

We just upgraded from Istanbul to Kingston and we realized that when exporting decimal values in CSV format the decimal delimiter is changed from the comma to a dot.

For example 2,15 is changed to 2.15

When exporting in Excel format the decimal delimiter stays the same.

Is there any configuration to define the decimal delimiter?

Thank you

[Chalan B L]

Hello Sergio,

CSV - comma seperated value. Basically all the values are separated by comma.

Just to have a look open CSV file in notepad++/notepad[Better to use notepad++] and check it out once.

tried again in our organization instance as well with the decimal fields and it is working as expected also our instance is in London so i would recommend you to follow the same steps.

Tried in my personal instance

Exported the file to CSV and opened the file in notepad

Please mark the answer as correct if it helped you..!!!

Regards.

Chalan

[Sergio26]

Hello,

In our case we have comma separated values in ServiceNow.

When we export to CSV format it changes to a dot delimiter.

We don't have this behavior with our current version (Istanbul).

[Chalan B L]

Since it seperates by comma and it is considering 1,5 as 1.5 ..

All i could suggest is to raise an HI ticket because this is how CSV file works.

Please mark the answer as correct if this helped you..!!!

Regards,

Chalan

[Sergio26 · Accepted solution]

Turns out we fixed the issue while resolving another problem we had related to currencies.

We had to create a System property 'glide.system.locale' and set the value to 'fr.CA' (French Canada) as the localization regional parameter