Function

Purpose

Example

Result

ABS

Absolute value

Text(ABS(1))

Text(ABS(-1))

1

1

CEIL

Round up

Text(CEIL(1.1))

Text(CEIL(-1.1))

2

-1

FLOOR

Round down

Text(FLOOR(1.1))

Text(FLOOR(-1.1))

1

-2

FRAC

The fraction behind the decimal point

Text(FRAC(1.1))

0.1

ROUND

Round

Text(ROUND(1.4))

Text(ROUND(1.5))

Text(ROUND(-1.4))

Text(ROUND(-1.5))

1

2

-1

-2

SIGN

Sign of the number

Text(SIGN(2))

Text(SIGN(0))

Text(SIGN(-2))

1

0

-1

TRUNC

Truncation of the decimals

Text(TRUNC(1.4))

Text(TRUNC(1.5))

Text(TRUNC(-1.4))

Text(TRUNC(-1.5))

1

1

-1

-1

NEG

Negative value

Text(NEG(5))

Text(NEG(-5))

-5

5

MAX

The maximum of two values

Text(MAX(1,2))

2

MIN

The minimum of two values

Text(MIN(1,-2))

-2

MID

The mean of two values

Text(MID(1,2))

1.5

RANDOM

A random number between 0 and Max (integer number)

Set(Max,1e8)

Text(RANDOM(Max))

76523821

ISREAL

Checks if a value is a number or not

Text(ISREAL('abc'))

Text(ISREAL(123))

FALSE

TRUE

FILEDATE

Gives the file date

Text(FILEDATE('Test.xls'))

45260.567

FILEEXISTS

Checks if a file exists

Text(FILEEXISTS('Test.xls'))

TRUE

FINDFIRST

The first file name in the specified folder; index 1..9

Text(FINDFIRST(1,'C:\temp\*.vnf'))

demo.vnf

FINDNEXT

The following file name in the previously specified

folder; index 1..9

Text(FINDNEXT(1))

test.vnf

FINDFIRSTDIR

The first directory in the specified folder; index 1..9

Text(FINDFIRSTDIR(1,'C:\temp\*.*'))

Gaia

FINDNEXTDIR

The following directory in the previously specified folder; index 1..9

Text(FINDNEXTDIR(1))

Vision