Random() (comma seperator)

[ptrex]

I have noticed that numbers returned from the Random() function, does take in account the International settings of the PC.

like if 7.012654699 is returned, it shows a DOT instead of using a COMMA as a decimal seperator.

In some countries like ours they use a COMMA as decimal seperator and a DOT as thousand seperator.

This might sound trivial but when exporting data Using COM to Excel the figures are not recognized correctly.

I took a look in the helpfile but could not find a function to convert it properly.

Is this correct ?

[Nuffilein805]

I have noticed that numbers returned from the Random() function, does take in account the International settings of the PC.

like if 7.012654699 is returned, it shows a DOT instead of using a COMMA as a decimal seperator.

In some countries like ours they use a COMMA as decimal seperator and a DOT as thousand seperator.

This might sound trivial but when exporting data Using COM to Excel the figures are not recognized correctly.

I took a look in the helpfile but could not find a function to convert it properly.

Is this correct ?

try this 1:

$a = random (1, 100)
$a = stringreplace ($a, ".", ",")

this should work

[jpm]

I have noticed that numbers returned from the Random() function, does take in account the International settings of the PC.

like if 7.012654699 is returned, it shows a DOT instead of using a COMMA as a decimal seperator.

In some countries like ours they use a COMMA as decimal seperator and a DOT as thousand seperator.

This might sound trivial but when exporting data Using COM to Excel the figures are not recognized correctly.

I took a look in the helpfile but could not find a function to convert it properly.

Is this correct ?

Random return what is usable by autoit.

It is true that Autoit works only with English/American number. So it is not a bug but the decimal point/coma has to be handle by the scripter.

[MSLx Fanboy]

try this 1:

$a = random (1, 100)
$a = stringreplace ($a, ".", ",")

this should work

What happens when you have

$a = random(1000, 10000)

$a could equal 8,473.3844. How do you propose a string replace? I would instead do something like

$a = random(1000, 10000)
 $a = StringReplace($a, ',', '\')
 $a = StringReplace($a, '.', ',')
 $a = StringReplace($a, '\', '.')
 MsgBox(0, '', $a)

Edited October 24, 2005 by MSLx Fanboy

[Valik]

What happens when you have

$a = random(1000, 10000)

$a could equal 8,473.3844.

No it can't. It might equal 8473.3844 but there will not be a comma in there.

[MSLx Fanboy]

hehe, nevermind then

[Nuffilein805]

i thought that my little thing might be the easiest 1

[jpm]

as it is not a bug I move it to Support forum so you can continue the discussion if you need

[ptrex]

@Nuffilein805

Your solution solved the problem. Thanks

Anyhow shouldn't there be any standard functions in AutoIT, to support these kind of conversions.

Isn' t is a good idea to have some kind of International support available, since AutoIt is used internationally.

[Nuffilein805]

ok i just made a udf for that

here it is:

$a = random (1, 100)
$b = DOT2COMMA($a)
msgbox (0, $a, $b)

Func DOT2COMMA($number)
    Select
    Case StringInStr ($number, ".")
        $number = StringReplace ($number, ".", ",")
        Return $number
    Case StringInStr ($number, ",")
        $number = StringReplace ($number, ",", ".")
        Return $number
    EndSelect
EndFunc

+ a little demo

works fine here

dot2comma.au3

[ptrex]

@Nuffilein805

Perfect !!

Maybe you can apply to have this build in as a standart UDF.

Thanks again

[Nuffilein805]

just posted it in scripts and scraps maybe they include it

we'll see, would be fun if they would (yeah my udf in autoit )

enough dreaming of being famous