8.4.36 InStrRev Function

Returns the position of an occurrence of one string within another, from the end of string.
Syntax
InStrRev(string1, string2[, start[, compare]])
Arguments
- string1
- The string expression being searched. Required.
- string2
- The string expression being searched for. Required.
- start
- The numeric expression that sets the starting position for each search. If omitted, -1 is used, which means that the search begins at the last character position. If start contains Null, an error occurs. Optional.
- compare
- The numeric value indicating the kind of comparison to use when evaluating substrings. If omitted, a binary comparison is performed. See Settings section for values. Optional.
Settings
The compare argument can have the following values:
Constant
|
Value
|
Description
|
vbBinaryCompare
|
0
|
Perform a binary comparison.
|
vbTextCompare
|
1
|
Perform a textual comparison.
|
Return Values
InStrRev returns the following values:
If
|
InStrRev returns
|
string1 is zero-length
|
0
|
string1 is Null
|
Null
|
string2 is zero-length
|
start
|
string2 is Null
|
Null
|
string2 is not found
|
0
|
string2 is found within string1
|
Position at which match is found
|
start > Len(string2)
|
0
|
Remarks
Note that the syntax for the InStrRev function is not the same as the syntax for the InStr function.
Copyright © 2000 Chili!Soft
|