Relation:Functions

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.

Mathematical functions

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

Text functions

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

Date functions

name example result
secondstosql(number) secondstosql(1000000000) 2001-09-09 03:46:40
sqltoseconds(text) sqltoseconds("2000-01-01") 946681200

Other

name example result
rownumber rownumber 5 (rownumber is not a function, but a constant, no paranthesis)