INDEX_OF
Description
Returns an integer constant indicating the index of the first string within the second string. For example,
INDEX_OF('fox', 'red fox')
returns 5. If the first string is not contained within the second one 0 is returned.
Syntax
INDEX_OF (search, text[, occurrence])
Can be used in the condition of a FIND action.
Parameters
Two attributes of the Plain Text type or two string constants or calculations producing text. A third parameter can be optionally specified – this parameter indicates occurrence number of the first string in the second string.
Returns
Number: the 1-based position of the first string in the second, or 0 if not found.
Example
IF INDEX_OF ('Smith', Account.Name) = 0 THEN ...