Sign in to follow this  
Followers 0
lebordeluche

converting some , in . (decimal point)

4 posts in this topic

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

Share this post


Link to post
Share on other sites



Hello,

just treat the "number" as a string first:

$s = "12,3"

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

ConsoleWrite($s)

ciao

Xandl

Share this post


Link to post
Share on other sites

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)

:D


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

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)

:D

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

Thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0