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

Object Data Type Description
searchText String The string to find.
value String The string to find it in.

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.