Last updated: Jan 17, 2024
This page describes the conventions used throughout this guide when referring to items in a function.
Convention | Description |
---|---|
BOOL | A Boolean, or flag, such as true or false. |
NUM, NUM1, NUM2 | Any number. |
REAL, REAL1, REAL2 | Any real number, such as 1.234 or –77.01 . |
INT, INT1, INT2 | Any integer, such as 1 or –77 . |
CHAR | A character code, such as `A` . |
STRING | A string, such as "referrerID" . |
LIST | A list of items, such as ["abc" "def"] or [A1, A2, A3] or
[1 2 4 16] . |
ITEM | A field, such as Customer or extract_concept . |
DATE | A date field, such as start_date , where values are in a format such as
DD-MON-YYYY . |
TIME | A time field, such as power_flux , where values are in a format such as
HHMMSS . |
Functions in this guide are listed with the function in one column, the result
type (integer, string, and so on) in another, and a description (where available) in a third column.
For example, following is a description of the rem
function.
Function | Result | Description |
---|---|---|
INT1 rem INT2
|
Number | Returns the remainder of INT1 divided by INT2. For example, INT1 –
(INT1 div INT2) * INT2 . |
Details on usage conventions, such as how to list items or specify characters in a function, are described elsewhere. See CLEM datatypes for more information.