Function:  

LAST_INDEX_OF  

Description:  

Returns an integer constant indicating the last index of the first string within the second string. For example, LAST_INDEX_OF(‘r, ‘bright red fox’) returns 8. If the first string is not contained within the second one 0 is returned.  

Parameters:  

Two attributes of the Plain Text type or two string constants or calculations producing text  

Example:  

If  LAST_INDEX_OF (‘Smith’, Account.Name) = 0 Then …

    

Function:  

LENGTH  

Description:  

Returns an integer constant indicating the number of characters in the provided text  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text  

Example:  

If  LENGTH (Account.Name) =  5 Then …

   

Function:  

MATCHES  

Description:  

Returns ‘Yes’ if the specified string matches the specified regular expression  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text and a regular expression  

Example:  

If  MATCHES (Customer.PhoneNo, ‘[0-9]’) =  ‘No’ Then …

   

Function:  

PAD_LEFT  

Description:  

Pads the given string on the left with the specified character  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text identifying the string to pad; the character to pad with; the resulting length of the string  

Example:  

PAD_LEFT ('John', '0', 6) returns '00John'

   

Function:  

PAD_RIGHT  

Description:  

Pads the given string on the right with the specified character  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text identifying the string to pad; the character to pad with; the resulting length of the string  

Example:  

PAD_RIGHT ('John', '0', 6) returns 'John00'

   

Function:  

REPLACE_PATTERN  

Description:  

Returns the text being the replacement of all occurrences of the old pattern in the provided text with the new pattern  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text; the text indicating the old pattern (supports format of regular expressions) and the text indicating the new pattern  

Example:  

If  REPLACE_PATTERN (Account.Name, ‘ohn’, ‘ack’) =  ‘Jack Smith’ Then …

   

Function:  

SUBSTRING  

Description:  

Extracts a string between two indexes of the given string (the second index is not inclusive)  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text and two indexes  

Example:  

If SUBSTRING (Account.Name, 0, 4) = ‘John’ Then

    

Function:  

TO_LOWER_CASE  

Description:  

Returns the text being the lower case representation of the provided text  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text  

Example:  

If  TO_LOWER_CASE (Account.Name) =  ‘john smith’ Then …

   

Function:  

TO_UPPER_CASE  

Description:  

Returns the text being the upper case representation of the provided text  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text  

Example:  

If  TO_UPPER_CASE (Account.Name) =  ‘JOHN SMITH’ Then …

   

Function:  

WORDS_FROM_LEFT  

Description:  

Returns the text being the specified number of the leftmost words in the provided text  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of words to retrieve  

Example:  

If  WORDS_FROM_LEFT (Account.Name, 1) =  ‘John’ Then …

   

Function:  

WORDS_FROM_RIGHT  

Description:  

Returns the text being the specified number of the rightmost words in the provided text  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of words to retrieve  

Example:  

If  WORDS_FROM_RIGHT (Account.Name, 1) =  ‘Smith’ Then …

   

Function:  

WORD_NUMBER  

Description:  

Returns an integer constant indicating the number of words in the provided text  

Parameters:  

Attribute of the Plain Text type or string constant or calculation producing text  

Example:  

If  WORD_NUMBER (Account.Name) > 2 Then …