Is Split Buggy? Why Isn't 0 a Number?

[NotLKH]

Originally posted by Kaverin
This is what I saw (after changing the msgbox to debug.print, because msgbox is very annoying).

4 is numeric
+ is not numeric
3 is numeric
+ is not numeric
2 is numeric
+ is not numeric
1 is numeric
+ is not numeric
0 is numeric

I'm at a loss to explain what you're seeing, but I see it like I expect.

This is Strange, Assuming you used My Tweek of your code, I ReTested it with DeBug.Print, and Received this:

4 is numeric
+ is not numeric
3 is numeric
+ is not numeric
2 is numeric
+ is not numeric
1 is numeric
+ is not numeric
0 is not numeric

So, the Difference, since you have VB5, could be You are passing the elements of split back as strings.

AAAHA!

Check this out!

Private Sub Command2_Click()
    Dim v2 As Variant
    v2 = "0"
        Select Case v2
            Case IsNumeric(v2)
                MsgBox v2 & " is numeric"
            Case Else
                MsgBox v2 & " is not numeric"
        End Select
    v2 = "1"
        Select Case v2
            Case IsNumeric(v2)
                MsgBox v2 & " is numeric"
            Case Else
                MsgBox v2 & " is not numeric"
        End Select
End Sub

Apparantly, variants don't evaluate correctly as Numeric, if = 0!

Strange!

-Lou