Returns the rightmost starting position of one string inside another.
InStrRev( x, y ) InStrRev( x, y, z ) InStrRev( x, y, z, w )
x | The input string to check to see the position of a substring | |
---|---|---|
y | The substring to search for in x. | |
z | The starting position to start searching in x 1) | OPTIONAL, default is -1, which is the end of the string |
w | This decides whether to compare case-sensitive(0) or not (1) | OPTIONAL, default is 0 |
A number.
InStrRev( "aaabbbaaaaaabbb","bbb" ) // Returns 13.
formula = InStrRev( "aaabbbaaaaaabbb","bBb",7,0 ) // Returns 0