The extraction boxes
The automation boxes
The transformations boxes
A short summary of the main functions available:
[*]Operators: + - * / ^
[*]Comparison: ==, >, <, <=, >=, !=
[*]Logical: &&,||
[*]Condition: (x>a?”True”:”False”)
[*]Format: ftoa, atof, itoa
[*]Math: abs, floor, ceil, round, sum, max, min, sqrt…
[*]Char: right, left, substr, strlen, toupper, tolower, indexof…
[*]Special: isNull, nDaysInMonth,nvl
[*]Constants: _pi, _e, _n, _null