Comparing variant string variables as numbers

[BobWolfe]

I was extracting numbers from a text file and trying to find the maximum of them. The max was 9999, which surprised me.

Then I realized the numbers were being compared alphabetically.

The extract below shows the problem with the last comparison showing the surprising result that that 12142 <7979

;Problem with comparing variant variables

;Strings compare correctly to numbers

;Strings do not compare correctly as numbers

;How do I fix this?

$IID = "12142"

$MaxIID="7979"

$Q = (10000 < $MaxIID)

MsgBox(0,"True? " & 10000 & " < " & $MaxIID,$Q)

$Q = (10000 > $IID)

MsgBox(0,"True? " & 10000 & " > " & $IID,$Q)

$Q = ($IID < $MaxIID)

MsgBox(0,"True? " & $IID & " < " & $MaxIID,$Q)

[Xenobiologist]

Hi,

you mean...?

$IID = "12142"
$MaxIID = "7979"
$Q = (10000 < $MaxIID)
MsgBox(0, "True? " & 10000 & " < " & $MaxIID, $Q)
$Q = (10000 > $IID)
MsgBox(0, "True? " & 10000 & " > " & $IID, $Q)
$Q = (Int($IID) < Int($MaxIID))
MsgBox(0, "True? " & $IID & " < " & $MaxIID, $Q)

So long,

Mega

[xcal]

Can use Number(), too.