Returns an integer specifying the start position of the first occurrence of one string within another.
Public Shared Function InStr(_ ByVal Start As Integer, _ ByVal String1 As String, _ ByVal String2 As String, _ Optional ByVal Compare As Microsoft.VisualBasic.CompareMethod _ ) As Integer
The compare argument settings are:
Constant | Value | Description |
---|---|---|
Binary | 0 | Performs a binary comparison |
Text | 1 | Performs a text comparison |
If | InStr returns |
---|---|
String1 is zero length or Nothing | 0 |
String2 is zero length or Nothing | start |
String2 is not found | 0 |
String2 is found within String1 | Position where match begins |
Start > String2 | 0 |
Exception type | Error number | Condition |
---|---|---|
5 | Start < 1. |
This example uses the InStr function to return the position of the first occurrence of one string within another.
Dim SearchString, SearchChar As String Dim MyPos As Integer SearchString ="XXpXXpXXPXXP" ' String to search in. SearchChar = "P" ' Search for "P". ' A textual comparison starting at position 4. Returns 6. MyPos =InStr(
4,
SearchString,
SearchChar,
CompareMethod.Text)
' A binary comparison starting at position 1. Returns 9. MyPos =InStr(
1,
SearchString,
SearchChar,
CompareMethod.Binary)
' Comparison is binary by default (last argument is omitted). MyPos =InStr(
SearchString,
SearchChar)
' Returns 9. MyPos =InStr(
1,
SearchString,
"W")
' Returns 0.
InStrRev Function | Option Compare Statement | StrComp Function |