VBScript InStrRev Function
 Complete VBScript Reference
The InStrRev function returns the position of the first occurrence of one
string within another. The search begins from the end of string, but the
position returned counts from the beginning of the string.
The InStrRev function can return the following values:
- If string1 is "" - InStrRev returns 0
- If string1 is Null - InStrRev returns Null
- If string2 is "" - InStrRev returns start
- If string2 is Null - InStrRev returns Null
- If string2 is not found - InStrRev returns 0
- If string2 is found within string1 - InStrRev returns the position at which
match is found
- If start > Len(string1) - InStrRev returns 0
Tip: Also look at the InStr function
Syntax
|
InStrRev(string1,string2[,start[,compare]])
|
| Parameter |
Description |
| string1 |
Required. The string to be searched |
| string2 |
Required. The string expression to search for |
| start |
Optional. Specifies the starting
position for each search. The search begins at the last character position
by default (-1) |
| compare |
Optional. Specifies the string comparison to use.
Default is 0 Can
have one of the following values:
- 0 = vbBinaryCompare - Perform a binary comparison
- 1 = vbTextCompare - Perform a textual comparison
|
Example 1
Dim txt,pos
txt="This is a beautiful day!"
pos=InStrRev(txt,"his")
document.write(pos)
Output:
2
|
Example 2
Dim txt,pos
txt="This is a beautiful day!"
'textual comparison
pos=InStrRev(txt,"B",-1,1)
document.write(pos)
Output:
11
|
Example 3
Dim txt,pos
txt="This is a beautiful day!"
'binary comparison
pos=InStrRev(txt,"T")
document.write(pos)
Output:
1
|
Example 4
Dim txt,pos
txt="This is a beautiful day!"
'binary comparison
pos=InStrRev(txt,"t")
document.write(pos)
Output:
15
|
Complete VBScript Reference
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
