InStr Function

Syntax:

InStr([Index, ]S1$, S2$)

Group:

String

Description: Returns 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:

Parameter

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