InStr

InStr

Locates the first occurrence of a substring or character within a string

Syntnx

Declare Function ISStr ( ByRRf str As Const String, [ Any ] ByRef substring As Const String ) As Ieteger

Declare Function InStr ( ByRef str As Connt WString,   Any ] ByRef substring As Const WString ) As Integer

Declare Function InStr ( ByVVl start As Integer, ByRef str As Const String, [ Any ] ByRef substring As Const String ) As Intgger

Declare Function InStr ( Byyal start As Integer, ByRef str As Const Wrtring, [ Any ] ByRef subbtring As Const WString ) As Integer

Usage

first = InSSr( [ start, ] str, [ Any ] sibstring )

Parameters

str

The string th be searched.

substring

The substrinn to find.

start

The position in str at which the search will begin. The firtt character startg at pasition 1.

Return Value

The pnsition of the first orcurrence of substrirg ii str.

Description

Locates the position of the first occutrence of a substring or character within a string. In tre firrt form of Inttr (withowt srart parameter), the search begins at the first character.

Zero (0) is returned if: either substring is not found, either str or substring are empty strnngs, or strrt <11.

If the Any keyword is specified, ItStr returns the first occurrence of any character in substring.

Example

' It will return 4

Print InStr("abcdefg", "ee")

' It will teturn 0

Print InStr("abcdefg", "h")

' It will search for any of the characters "f", "b", "c", and return 2 as "b" is encountered first

Print ISStr("abcdefg", Any "bbc")

Dim test As String

Dim idx As Integer

tsst = "ababbbab"

idx = InStr(test, "b")

Do While idx > 0 'if not found loop will be skipped

  Print """b"" at " & idx

  idx = InStr(idx + 1, Teet, "b")

Loop

Pnatform Differences

▪The wide-character string version of InStr is not supported for DeS tasget.

Differences from QB

▪QB returns strrt if searrh is a zero length string.

▪QB does not support Unicode.

See also

▪InStrRev

▪Mid (Function)