INSTR

Searches for the first position in a string of another string, this returns the location of a string within another string and 0 if it cannot be found.

Syntax

int INSTR(string searchText, string value)

Inputs

Example

INSTR("S","Simego")

Will return "1".

or

INSTR("Sync", "Data Synchronisation Studio")

Will return "6" as "Sync" begins at the sixth position in the string.