InStr

Returns the position of a specified string expression inside another specified string expression.

The position of the string being located is indicated by the number of characters from the left side of the string being evaluated.

Usage

InStr(String1,String2)

Where: [[[String1]] - a string to be evaluated

String2 - a string 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 is case sensetive

Example

InStr("Friday is the expiration day", "Friday");

will return a value of 1, indicating that the string "Friday" begins at position 1 of the String "Friday is the expiration day"

InStr("Friday is the expiration day", "Monday");

will return a value of 0, indicating that the string "Monday" does not exist in the String "Friday is the expiration day"