Name
InstrRev Function
Syntax
InstrRev(sourcestring
,soughtstring
[,start
[,compare
]])
sourcestring
Use: Required
Data Type: String
The string to be searched.
soughtstring
Use: Required
Data Type: String
The substring to be found within
sourcestring
.start
Use: Optional
Data Type: Numeric
Starting position of the search. If no value is specified,
start
defaults to 1.compare
Use: Optional
Data Type: Integer
The method that compares
soughtstring
withsourcestring
; its value can bevbBinaryCompare
orvbTextCompare
Return Value
Variant of type Long.
Description
Determines the starting position of a substring within a string by searching from the end of the string to its beginning.
Rules at a Glance
While InStr searches a string from left to right, InStrRev searches a string from right to left.
vbBinaryCompare
is case-sensitive; that is, InstrRev matches both character and case, whereasvbTextCompare
is case-insensitive, matching only character, regardless of case.The default value for
compare
isvbBinaryCompare
.start
designates the starting point of the search and is the number of characters from the start of the string.If
start
is omitted, the search begins from the last character insourcestring
.sourcestring
is the complete string in which you want to find the starting position of a substring.If
soughtstring
isn’t found, InStrRev returns 0.If
soughtstring
is found withinsourcestring
, the value returned by InStrRev is the position ofsourcestring
from the start of the string.
Programming Tips and Gotchas ...
Get VBScript in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.