InStr Function
Syntax
InStr([Index, ]S1$, S2$)
Group
Description
Return the index where S2$ first matches S1$. If no match is found return 0.
NOTE: A similar function, InStrB, returns the byte index instead.
Parameters
Parameters | Description |
---|---|
Index | Start searching for S2$ at this index in S1$. If this is omitted then start searching from the beginning of S1$. |
S1$ | Search for S2$ in this string value. If this value is Null then Null is returned. |
S2$ | Search S1$ for this string value. If this value is Null then Null is returned. |
Example
Sub Main Debug.Print InStr("Hello","l") ' 3 End Sub
See also
InStrRev( ), Left$( ), Len( ), Mid$( ), Replace$( ), Right$( )