InStrRev

Return the position of one string within another, starting at the end of the string.

Syntax
      InstrRev ( FullString, PartString, [start], [compare] )

Key
   FullString  The String (expression) to be searched.

   PartString  The String (expression) being sought.

   Start       Number (expression) that sets the start position for each search.
               Default = -1 (the last character)

   compare     The comparison mode (Binary/Text)

The InStrRev() function can be used in VBA or in an SQL query.
The syntax for the InstrRev function is not consistent with the syntax for the Instr function.

Return values

If                          InStrRev() returns
String is found             Position at which match is found
FullString is zero-length   0
FullString is shorter than start  0
FullString is Null          Null

PartString is zero-length   start
PartString is Null          Null
PartString is not found     0

Example

Dim intDemo as Integer
intDemo = InStrRev("The Universe is expanding", "U")
MsgBox intDemo

“One look is worth a thousand words” ~ Fred R. Barnard

Related:

Instr - Return the position of one string within another


Copyright © SS64.com 1999-2019
Some rights reserved