Function:  

AS_DATE  

Description:  

Converts the given string into a date according to the specified format.  

Parameters:  

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

Example:  

Object.DateAttr =  AS_DATE (’02-25-2007’, ‘MM-dd-yyyy’)

    

Function:  

AS_NUMBER  

Description:  

Converts the given string into a number. If a string cannot be converted the original string is returned.  

Parameters:  

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

Example:  

If  AS_NUMBER (Account.Text) =  5 Then …

   

Function:  

AS_STRING  

Description:  

Converts the given attribute or expression of the Number, Date, Timestamp, Yes/No or Plain Text types into a string.  

Parameters:  

Attribute or expression of the Number, Date, Timestamp, Yes/No or Plain Text types  

Example:  

If  AS_STRING (Account.Number) =  ‘5’ Then …

   

Function:  

AS_TIMESTAMP  

Description:  

Converts the given string into a timestamp according to the specified format.  

Parameters:  

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

Example:  

Object.TimeStampAttr =  AS_TIMESTAMP (’02-25-2007 10:05’, ‘MM-dd-yyyy HH:mm’)

   

Function:  

CHARS_FROM_LEFT  

Description:  

Returns the text being the specified number of the leftmost characters 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 characters to retrieve  

Example:  

If  CHARS_FROM_LEFT (Account.Name, 2) =  ‘Jo’ Then …

   

Function:  

CHARS_FROM_RIGHT  

Description:  

Returns the text being the specified number of the rightmost characters 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 characters to retrieve  

Example:  

If  CHARS_FROM_RIGHT (Account.Name, 3) =  ‘ith’ Then …

   

Function:  

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.  

Parameters:  

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