Table of Contents

, ,

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 ... 

LAST_INDEX_OF, SUBSTRING, LENGTH, MATCHES