Comma Instead of Point ?

[#1]

Hi All;

I have a fied below that name is 'Value'

I would like to show data such as 15,52 instead of 15.52

So i would like to show comma(,) instead of point(.)

Value
15.52
15.53
15.55
15.62
15.64
15.66
15.74
15.82
15.85

Thanks in advance...

[kji]

Change the number format for the field/listbox and give , as your decimal separator.

[#3]

it does not work anyway.

Any idea ?

[#4]

Use replace it will work. Search with replace in forum you will see number of examples

[#5 · Accepted solution]

To be correct

Replace(Value,'.',',');

[Miguel_Angel_Baeyens]

Hi,

Depending on what you want to do in your document, you may need to change this variable in the main tab yof your script

SET DecimalSep='.'; // . instead of ,

You can use replace as well, but it may not work if you are going to say sum those values

LOAD Replace(value, ',', '.') as value FROM...

Hope that helps

[#7]

I use replace function and it works...


Thanks.