What is the funda behind Number and String compare?

[nbala75]

$A=50.2 (derived from webpage)

$B=50.20 (derived from an excel sheet)

It doesnt work when i say:

If $A=$B then

Msgbox(0,"","Equal")

Endif

It doesnt work when i declare like this also:

$A=Number(50.2)

$B=Number(50.20)

If $A=$B then

Msgbox(0,"","Equal")

Endif

It works when i do something like this:

$A=Number((50.2)&"0")

$B=Number(50.20)

If $A=$B then

Msgbox(0,"","Equal")

Endif

Apparently it took a long time for me to isolate this problem.....can some learned explain to me what is the funda behind this?

[GEOSoft]

Even that is doing it the hard way. You forced $a to be the same as $b and you are using a string comparison.

There are a few ways to skin this cat, here are but 2 of them

$a = 50.2
$b = 50.20

MsgBox(0, "TEST", "Using Mod(): " & Mod($a, $b) & @CRLF & "Using Subtraction: " & $a - $b & @CRLF)

In either case a return value of 0 means they are equal.

so your code would go something like this

$a = 50.2
$b = 50.20
$bRtn = False
If NOT Mod($a, $b) Then
    $bRtn = True
EndIf
MsgBox(0, "Result", $bRtn)

[Melba23]

nbala75,

You get the data as strings so it is not surprising that they are not equal in the first test as AutoIt looks at them as strings.

In the second test you have the wrong syntax for Number - go and look in the Help file how you should do it.

Here is the proper way to test that data:

; Compare as strings - this will fail because they are not identical
$A = "50.2"
$B = "50.20"

If $A = $B Then
    MsgBox(0, "String", "Equal")
EndIf

; Convert those strings to numbers - this will work as the values are the same
$A = Number($A)
$B = Number($B)

If $A = $B Then
    MsgBox(0, "Number", "Equal")
EndIf

; Use the correct syntax to convert strings to numbers - this will work as the values are the same
$A = Number("50.2")
$B = Number("50.20")

If $A = $B Then
    MsgBox(0, "Number string", "Equal")
EndIf

Basically if you want to compare numerical values you need to get the variables into number format using Number correctly.

All clear?

M23

[GEOSoft]

All clear?

M23

Sure it is but Mod is just so simple; no conversions to do since it assumes a numerical input.

[nbala75]

In the second test you have the wrong syntax for Number - go and look in the Help file how you should do it.

M23

I might have given it wrongly here. But when i tried to covert that as Number (as per help file notations), it never worked...

But tell me one thing...in so many other places, i never used to convert it into Number or String for proper comparisons (unlike other languages), it failed here at this instance only.

I also remember to have read somewhere that for using $A=$B, we need not convert it into Number formats...not sure where i read in help file

Edited February 21, 2011 by nbala75

[nbala75]

Sure it is but Mod is just so simple; no conversions to do since it assumes a numerical input.

Sure, thanx, will use Mods henceforth for these types

[JoHanatCent]

Sure, thanx, will use Mods henceforth for these types

R U Sure?

$a = 100.4;<<< = Per accident you can find this !!!!!!!!!

$b = 50.20
$bRtn = False
If NOT Mod($a, $b) Then
    $bRtn = True
EndIf
MsgBox(0, "Result1", $bRtn)

; ===   Where as ===

If Number($a) = Number($b) Then
        MsgBox(0, 'Result', 'True', 5)
Else
        MsgBox(0, 'Result', 'False', 7)
EndIf

Added ; === Where As ===

Edited February 22, 2011 by JoHanatCent

[Malkey]

Sure, thanx, will use Mods henceforth for these types

And another reason not to use Mod($a, $a) is:-

When $b = 1, the result is always True.

Also when $b = 0 and $a = 0 a Microsoft error is generated on my xp.

; When $b = 1, Result is always True.
$a = 2
$b = 1
MsgBox(0, "Result", Mod($a, $b) = 0)

; Error, send Microsoft an error report or not. (using xp OP)
$a = 0
$b = 0
MsgBox(0, "Result", Mod($a, $b) = 0)

[JoHanatCent]

When $b = 1, Result is always True.

Error, send Microsoft an error report or not. (using xp OP)

True. Mod is a division sum so If one divide A by 1 you should get back A

Please don't send Mocrosoft an Error report because dividing A by 0=Zero is suppose to give us an error!

[nbala75]

Iam pretty screwed up now

The things which were working just right earlier are not working now...i think i really messed up the Number(" ") things here and there.

Tell me, can i not use String=String? Or shud i use only StringCompare ??

This is just sucking my time.. :idiot:

Edited February 22, 2011 by nbala75

[nbala75]

JoHanatCent and Malkey....thanx

[Melba23]

nbala75,

Just do as I suggested in my post a long way above and you will get the correct results.

M23