Functions are used in expressions to make calculations. Functions have 0 or more parameters that must be number or text and return a text.
There are a number of predefined functions, but you can also define your own with the instruction function.
name |
example |
result |
abs(number) |
abs(-4) |
4 |
ceil(number) |
ceil(3.6) |
4 |
cos(number) |
cos(3.14/4) |
0.7073883 |
exp(number) |
exp(2) |
7.389056 |
floor(number) |
floor(3.6) |
3 |
ln(number) |
ln(7.389056) |
2 |
log(number) |
log(7.389056) |
0.868589 |
max(number,number) |
max(3,5) |
5.000000 |
min(number,number) |
min(3,5) |
3.000000 |
pow(number,number) |
pow(2,3) |
8 |
rnd() |
rnd() |
0.7126855 |
round(number) |
round(3.6) |
4 |
sign(number) |
sign(-4) |
-1 |
sin(number) |
sin(3.14/6) |
0.4997701 |
sqrt(number) |
sqrt(2) |
1.414214 |
tan(number) |
tan(3.14/6) |
0.5769964 |
name |
example |
result |
format(number,spec) |
format(9.55,"%1.1f") |
9.5 |
length(text) |
length("FooBar") |
6 |
lower(text) |
lower("FooBar") |
foobar |
pad(text,number) |
pad("FooBar",16) |
FooBar |
regexreplace(text,pattern,newtext) |
regexreplace("FooBar","o+","U") |
FUBar |
replace(text,oldtext,newtext) |
replace("FooBar","o","a") |
FaaBar |
trim(text) |
trim(" FooBar ") |
FooBar |
upper(text) |
upper("FooBar") |
FOOBAR |
urltext(text) |
urltext("Foo Bar") |
foo-bar |
name |
example |
result |
secondstosql(number) |
secondstosql(1000000000) |
2001-09-09 03:46:40 |
sqltoseconds(text) |
sqltoseconds("2000-01-01") |
946681200 |
name |
example |
result |
rownumber |
rownumber |
5 (rownumber is not a function, but a constant, no paranthesis) |