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 |