Thursday, November 17, 2005

The InStrRev Function

The InStrRev function returns the position of the first occurrence of one string within another. The search begins from the end of string, but the position returned counts from the beginning of the string.

The InStrRev function can return the following values:

  • If string1 is "" - InStrRev returns 0
  • If string1 is Null - InStrRev returns Null
  • If string2 is "" - InStrRev returns start
  • If string2 is Null - InStrRev returns Null
  • If string2 is not found - InStrRev returns 0
  • If string2 is found within string1 - InStrRev returns the position at which match is found
  • If start > Len(string1) - InStrRev returns 0

Tip: Also look at the InStr function

Syntax

InStrRev(string1,string2[,start[,compare]])

Parameter Description
string1 Required. The string to be searched
string2 Required. The string expression to search for
start Optional. Specifies the starting position for each search. The search begins at the last character position by default (-1)
compare Optional. Specifies the string comparison to use. Default is 0

Can have one of the following values:

  • 0 = vbBinaryCompare - Perform a binary comparison
  • 1 = vbTextCompare - Perform a textual comparison

Example 1

dim txt,pos
txt="This is a beautiful day!"
pos=InStrRev(txt,"his")
document.write(pos)
Output:
2

Example 2

dim txt,pos
txt="This is a beautiful day!"
'textual comparison
pos=InStrRev(txt,"B",-1,1)
document.write(pos)
Output:
11

Example 3

dim txt,pos
txt="This is a beautiful day!"
'binary comparison
pos=InStrRev(txt,"T")
document.write(pos)
Output:
1

Example 4

dim txt,pos
txt="This is a beautiful day!"
'binary comparison
pos=InStrRev(txt,"t")
document.write(pos)
Output:
15

Reference: http://www.w3schools.com/vbscript/func_instrrev.asp


2 comments:

a.p.r. pillai said...

Nice Post. why don't you keep updating the site.

Thanks,
www.msaccesstips.com

StevenHWicker said...

I just want to thank you for sharing your information and your site or blog this is simple but nice Information I’ve ever seen i like it i learn something today. Bookkeeping