To convert comma to dot in decimal number

[Anonymous]

Hi all,

Could any one give me the syntax to change a decimal number with "." (dot) instead of ","(comma).

From database I am fethcing a field value and storing its first value to a variable using peek function.

The values in that fields are decimal number like below.

var_Value = 0,7854

Now I want to chamge this value so instead of "," I want ".". (i.e., Instead of 0,7854 I want 0.7854)

Because I am using this value in calculation.

Can any one help me in this??

Thank you

[#2 · Accepted solution]

use replace() function

=replace(var_Value,',','.')

[#3]

replace('0,7854',',','.') returns 0.7854

[er_mohit]

try this

LOAD Replace(F1,',','.')as New, * INLINE [

    F1

    "1,234"

    "2,4567"

    "4,678"

    "12,4566"

    "0,234"

    "0,8449"

];

[#5]

if your question is resolved then you have might to give either correct or helpful answer to closed this thread.

so that it might be helpful for other developers

Regards

vishwaranjan

[Anonymous]

Thanks for your solution. It worked. I didnt check your solution and that is the reason why I didnt mark my thread.

Sorry..

Thanks,

Leni Balakrishnan