Description
Returns the position of the first occurrence of a search string in a string field, when searching forward from the start index.
Syntax
INDEXOF(string, search_string, start_index)
Arguments
string - string expression
search_string - string expression to search for
start_index - integer index to start the search (string index starts at 0).
Examples
INDEXOF('What wonderful weather in a wonderful world','wonderful',15) returns 28.
Notes
The startIndex begins at 0.
If the search string is not found, -1 is returned.
Return value datatype
Int
Impact of null value
If any (or all) inputs are null, returns null.