converting some , in . (decimal point)

[lebordeluche]

Hello everybody

I'm working hard to convert numbers like 12,3 (comma separared) to float with a good float format with dot 12.3.

The number function return a int. I don't find any function to help me

(I read comma separated values from a website and I 'm trying to make some percentage with this value)

What is the good function to convert my "numbers"

Thanks

Patrice

[Xandl]

Hello,

just treat the "number" as a string first:

$s = "12,3"

$s = Number(StringReplace($s,',','.'))

ConsoleWrite($s)

ciao

Xandl

[PsaltyDS]

Xandl already got it, but you might want to watch out for stray white space, too:

$sData = "12,3"
$iData = Number(StringReplace(StringStripWS($sData, 8), ",", "."))
ConsoleWrite("Debug: $sData = " & $sData & "  $iData = " & $iData & @LF)

[lebordeluche]

Xandl already got it, but you might want to watch out for stray white space, too:

$sData = "12,3"
$iData = Number(StringReplace(StringStripWS($sData, 8), ",", "."))
ConsoleWrite("Debug: $sData = " & $sData & "  $iData = " & $iData & @LF)

I found this solution myself but I consider this solution "dirty" but it works

Thanks