The following is an overview of the functions and their available formats:
String
Function | Tooltip |
---|---|
(indexOf(String, int)) | Starting point of a string within another string starting at a defined point in the string. |
(indexOf(String)) | Starting point of a string within another string starting at the beginning of the string. |
(length()) | Length of a string. Formating a numeric field to a string, for example: numeric value of 9 with a format of "00000.00" would result in a string of "00009.00". |
(startsWith(String, int)) | Checking to ensure if a string starts within a defined string starting from a defined index. Needs to support indexOf. |
(startsWith(String)) | Checking to ensure if a string starts within a defined string. |
(endsWith(String)) | Checking to ensure if a string ends with a defined string. |
(substring(int)) | Pulling a substring from another string starting at a defined point till the end. This needs to support indexOf. |
(substring(int, int)) | Pulling a substring from another string starting at a defined point till a defined point in the string. This needs to support indexOf. |
(concat(String)) | Concatenating stings including being able to define numeric fields as strings. |
(contains(String)) | Checking to ensure if a string contains another string. |
Comparing strings | Not available. |
Numeric
Function | Tooltip |
---|---|
(toString(format)) | Converting a number or currency to a string with a defined format. |
(abs()) | Absolute value of a number |
(sqrt()) | Square root of a number. |
(power(int)) | Raised to the power. |
(log()) | Logarithm Base 10. |
(ln()) | Natural Logaritm. |
(min(number, ….)) | Minimum of a set of numbers. |
(max(number, ….)) | Maximum of a set of numbers. |
(ceil()) | Round up to the smallest integer that is greater than or equal to the value of the field. |
(floor()) | Round down to the largest integer that is less than or equal to the value of the field. |
(round(int)) | Round to the number of decimal places. |
Comparingnumbers =, !=, >, >=, <, <= | Not available. |
Date
Function | Tooltip |
---|---|
(toString(format)) | Converting a date to a string based on a defined format. |
Converting a datetime to a date only | Not available. |
Add or subtract number of days from a date | Not available. |
Add or subtract number of months from a date | Not available. |
Add or subtract number of years from a date | Not available. |
Extracting day, month, or year from a date. | Not available. |
Comparing Dates =, !=, >, < | Not available. |
The following provides the list of functions:
Note: Use the tooltip to learn more about each function.
String Functions | Numeric Functions | Date Functions |
---|---|---|
|
|
|