InStrRev is not working properly when i set the search criteria at "/" Why?

[kjy1989]

in this string, all is working, it returns 32.

Sub kingama()

Dim TESTNUMBER As Integer
Dim TESTSTRING As String
TESTSTRING = "the quick brown fox jumps over the lazy dog"


TESTNUMBER = InStrRev(TESTSTRING, "the")
MsgBox TESTNUMBER



End Sub

but when i run this:

Sub TESTING()

Dim TESTNUMBER As Integer
Dim TESTSTRING As String
TESTSTRING = "08/10000AF"

TESTNUMBER = InStrRev(TESTSTRING, "/")
MsgBox TESTNUMBER

End Sub

this string SHOULD return 8 right? but it doesnt, it returns a value of 3. Why is that so? i find it very unususual and i cannot find a solution to this!

[protonLeah]

INSTRREV started from the end of the string and found the second "the", but it counted from left to right to the 32nd position.
INSTRREV started from the end of the string and found "/" and counted from left to right to the 3rd position.
INSTR finds the first occurrence of x, INSTRREV finds the last, there were two "the"'s but only one "/".

[AlvaroSiza]

So by that rationale the only way to return 8 is:

Sub TESTING()

Dim TESTNUMBER As Integer
Dim TESTSTRING As String
TESTSTRING = "08/10000AF"

TESTNUMBER = InStr(1, TESTSTRING, "/")

TESTNUMBER = LEN(TESTSTRING) - TESTNUMBER + 1

MsgBox TESTNUMBER

End Sub

???