InstrRev

[dugdugdug]

Dim MyString As String

MyString = "ApplesandOranges"

Dim MyResult As Integer

MyResult = InStrRev(MyString, "Or", -1)

MyResult returns 10.

Shouldn't it be 6 or 7 (because you're counting from the end backwards, so starting with s, then e, then n then .....

 

[VoG]

InstrRev looks backwards to find the search string then returns the number of characters from the start.

 

[dugdugdug]

I don't understand.

I thought it was looking for the letters Or, starting from the last letter in "ApplesandOranges".

"InstrRev looks backwards", looking at Or or ApplesandOranges backwards?

 

[VoG]

It starts from the last letter of ApplesandOranges looking for Or. When it finds it, it returns the number of characters from the start ApplesandOranges

 

[dugdugdug]

Thanks.

Looking at this, VBScript InStrRev Function

the example

txt="This is a beautiful day!"
response.write(InStrRev(txt,"i",-1) & "
")

returns 15 because it is starting from the end and finds the i in bold red, then counts from the start.

But this example:

txt="This is a beautiful day!"
response.write(InStrRev(txt,"i",7) & "
")

returns 6.

The significance of the 7 means start from 7 (from the start or end)?

Either way, why is the answer 6?

 

[VoG]

I assume that Start counts from the end (Help is no use on this). But the important point is that it searches backwards then returns the character count from the first character.

 

[dugdugdug]

I think I've got it finally!

The 7 means it starts from the beginning, ie the "T", counts 7 characters including spaces, to get to the "s" in "is", then counts right to left until it finds an "i", which in this case is the one in "is" and finally counts from the beginning to this "i", hence 6!

 

[VoG]

Hoorah!

I must admit that when I first used it I got confused too.