The position of the string being located is indicated by the number of characters from the left side of the string being evaluated.
==== Usage ====<syntaxhighlight>InStr(String1,String2)</syntaxhighlight>
Where: [[[ :'''String1]] ''' - a string to be evaluated.
[[:'''String2]] ''' - a string expression to be located ==== Notes ==== In case the search returns no results 0 is returned In case if the sought word occurs more than once, the first position will be returned .
Search == Notes ==* In case the search returns no results, a 0 is returned.* In case if the sought word occurs more than once, the first position will be returned.* The search performed by InStr is case sensetive sensitive.
==== Example ==Examples ==
<syntaxhighlight>InStr("Friday is the expiration day", "Friday");</syntaxhighlight>
will Will return a value of 1, indicating that the string "Friday" begins at position 1 of the String "Friday is the expiration day" .
<syntaxhighlight>InStr("Friday is the expiration day", "Monday");</syntaxhighlight>
will Will return a value of 0, indicating that the string "Monday" does not exist in the String "Friday is the expiration day" .
[[Category:Text Manipulation]]