VBA-Excel : Strings Functions – InstrRev

Description:

InstrRev: This function returns the position of last occurrence of a string into another string, as a variant, based upon the arguments are provided, OR you can say that it returns the position of the first occurrence of a string into another string from the end of the string.

Format:

InStrRev(mainString, searchedString[,start, ] [, compare])

Arguments:

mainString
- Mandatory
- Type: String
- String being searched.
·searchedString
- Mandatory
- Type: String
- String to be searched
start
- Optional
- Type: Numeric
- Starting position from where search has to be started.(from end of the string, if string length is 10 then it starts with 10 to 1)
- Required if compare argument is specified
Compare
- Optional
- Specify type of string comparison.
- Settings

*Constant*	*Value*	*Description*
vbBinaryCompare	0	Performs a binary comparison.
vbTextCompare	1	Performs a textual comparison.
vbDatabaseCompare	2	Microsoft Access only. Performs a comparison based on information in your database.

INSTRRev

Results:

Condition	Result
mainString is zero-length	0
mainString is NULL	NULL
searchedString is zero-length	Start
searchedString is NULL	NULL
searchedString is not found	0
searchedString found in mainString	Position at which match is found
Start> searchedString	0

Function FnInstrRevOperations()

   Dim mainString

   Dim searchString

   mainString = "SumitJain"

   searchString = "i"

   MsgBox "Position of 'i' is " & InStrRev(mainString, searchString, 9, vbTextCompare)

   ' Output : Position is 'i' is 8
 

End Function

Also Read About Other String() Functions

INSTR() | InstrREV() | LCase()

UCase() | Left() | Right()

LTrim() | Mid() | Trim()

RTrim() | Replace() | Space()

Len() | StrComp() | String()

functions 16 string 15