Functions

A function name is given in capital letters and is followed by a parenthesis. Arguments are given within the parenthesis, separated by commas.

For example:

OLD (STAI)
ISBLANK (TRIM (CORI))
SUBSTRING (PARM, 1,2)

This table shows the available functions and their descriptions:


Functions	Description
IF(comparison, trueExpression, falseExpression)	Returns either trueExpression or falseExpression depending on the result of the comparison. Example expression for a virtual field: `IF(INDEXOF(FUDS,'ABC') >= 0, 'ABC', FUDS)`
INDEXOF(string, substring)	Returns the index of the first occurrence of the substring within the string, or -1 if there is no occurrence.
INDEXOF(string, substring, fromIndex)	Returns the index of the first occurrence of the substring within the string, starting at the specified index, or -1 if there is no occurrence.
ISBLANK(field)	Returns true if the field is empty; otherwise, the value returned is false.
ISCHANGED(field)	Returns true if the field has a different value than its old value; otherwise the value returned is false. This function can only be used for received events with the Update operation.
LENGTH(string)	Returns the length of the string. If a non-existent field is given, 0 is returned.
OLD(field)	Returns the old value of the field. This function can only be used for received events with the Update operation.
SUBSTRING(string, beginIndex, endIndex)	Returns a substring of the string. The attribute `beginIndex` is zero-based and inclusive. The attribute `endIndex` is zero-based and exclusive. For example, to extract 'CD' from the string 'ABCDE', use beginIndex = 2 and endIndex = 4.
TOUPPER(string)	Converts all characters in the string to uppercase.
TOLOWER(string)	Converts all characters in the string to lowercase.
TRIM(string)	Removes leading and trailing white space from the string.