Version: 2.0
The InStrRev function returns the numeric position of the first
occurrence of a specified substring within a specified string when
starting from the end (right end) of the string. You can have the
search for the substring be sensitive to the case (upper versus lower),
or not. The default is to be case sensitive (binary comparison).
An output of zero indicates no match.
Comparison Constants
CONSTANT | VALUE | DESCRIPTION |
---|---|---|
VBBINARYCOMPARE | 0 | Binary comparison (case sensitive) |
VBTEXTCOMPARE | 1 | Text Comparison (case insensitive) |
VBDATABASECOMPARE | 2 | Compare information inside database |
<% =InStrRev("ACBED ABCDE", "C")
%>
9
<% =InStrRev("ACBED ABCDE", "C", 4)
%>
2
In the example the search begins at postion 4, counted from the left, and the search goes from the right to left.
<% =InStrRev("ACBED ABCDE", "c", 4, 0)
%>
0
In the example, by using VBBinaryCompare, or 0, for the Compare argument, all upper/lower case differences are obeyed in both the search.
<% =InStrRev("ACBED ABCDE", "c", 4,
VBTextCompare %>
2
In the example, by using VBTextCompare, or 1, for the Compare argument, all upper/lower case differences are ignored in the search.