Expression Functions

Contents - Index - Previous - Next

Expression Functions

An expression consists of operators, functions and keywords.

The following functions are supported.

Numeric functions

Function Description Example
TRUNC Truncates a real number trunc(volau)
ROUND Rounds a real number round(ul1)
ABS Absolute value abs(xi)
ARCTAN Arctangent (in radians) arctan(ui1)
ARCTANA Arctangent (in degrees) arctana(ui1)
COS Cosine (in radians) cos(45)
COSA Cosine (in degrees) cosa(45)
SIN Sine (in radians) sin(45)
SINA Sine (in degrees) sina(45)
TAN Tangent (in radians) tan(45)
TANA Tangent (in degrees) tana(45)
EXP Exponential exp(ul2)
FRAC Fractional part of number frac(volau/100)
INT Integer part of nmber int(volau/100)
LN Natural logarithm ln(ui1)
LOG10 Base 10 logarithm log10(ui1)
FLOOR Returns the highest floor(x)
integer less than or
equal to X
CEIL Returns the lowest ceil(x)
integer greater than or
equal to X
PI Returns 3.14..... pi*45
SQR Square of a number sqr(xi)
SQRT Square root of a number sqrt(xi)
POWER Power of a number Power(3,2) = 9
MIN The minimum of two min(5,2) = 2
numbers
MAX The maximum of two max(100,101)=101
numbers
STR String equivalent 'Volume ='+Str(volau)
STRING String equivalent with 'Volume =' + String(volau,2)
decimals
RANDOM A random number Random*1000
between 0 and 1
ROUNDBY Rounds a number RoundBy(10206,100) = 10200

String Functions

Function Description Example
UPPER Upper case of string upper(mode)
LOWER Lower case of string lower(mode)
COPY Gets a substring copy('ABCDEF',2,3)='BCD'
in a string
POS Gets position of pos('C','ABCDEF')=3
substring in a string
STRLEN Length of a string strlen(ldesc)
TRIM Trims a string of leading trim(ldesc)
and trailing blanks

Logical Function

IF(Condition, TrueResult, FalseResult)