INDEX_OF

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.

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.

IF INDEX_OF ('Smith', Account.Name) = 0 THEN ... 
  • Last modified: 2023/05/09 00:58