<< Prev        Next >>

ID : 285

InStr

Function

To return a position of a specific string within a string.

Syntax

InStr(start position, target, search string)

Guaranteed entry

Start position
Designate a position to start searching within the string of target by integer type. Designate a numeric value of 1 or higher.
Target
Designate a search target string by string type data.
Search string
Designate a string to search within the target string by string type data.

Return value

Return a position of search string found in the target string by integer type data.

Status of guaranteed items Return value
The number of characters in a target string is 0 0
The number of characters in a search string is 0 Value of start position
Search string is not found 0
Search string is found within a target string Position of characters found
Value of start position exceeds the number of characters in a target string 0

Description

Look up a search string within the specified target from the left to the right. The search starts from the position that have been designated by the start position. Then a position where the search string is found first is returned.

Related Terms

Asc, Chr, SprintF, Left, Len, Mid, Right, Val, Bin

Attention

-

Example

'!TITLE "Acquiring String Position"
' Acquire the first position where the search target "bc" is matched in a string "abcdefg"
Sub Sample_StrPos 

  Dim aaa As Integer

  ' Assign 2 indicating a position of "bc" within "abcdefg" to aaa
  aaa = InStr( 1, "abcdefg", "bc" )

  ' Display 2 on the message output window
  PrintDbg aaa

End Sub

ID : 285

<< Prev        Next >>