InstrRev Function (VB6) |
Named Arguments
No
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
The starting position of the search. If no value is specified, start defaults to 1.
compare
Use: Optional
Type: vbBinaryCompare constant
The method that compares soughtstring with sourcestring ; its value can be vbBinaryCompare, vbTextCompare, or vbDatabaseCompare.
Return Value
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, whereas vbTextCompare is case insensitive, matching only character, regardless of case.
The default value for compare is vbBinaryCompare.
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 in source-string.
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 within sourcestring, the value returned by InStrRev is the position ...
Get VB & VBA in a Nutshell: The Language 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.