Examples

Expression

Result

Description

(2 + 3) * 5

25

The calculation is performed

THEME2

The value of the database column THEME2 is retrieved.

'C' + 1

'C1'

The number is converted to a string and concatenated to the constant 'C'.

upper('c')

'C'

The string is converted to upper case.

upper(THEME2)

The value of the database column THEME2 is converted to upper case

'A' in 'A,B,C'

true

The string 'A' is found in the list on the right.

Upper('a') in 'A,B,C'

true

The string 'a' is converted to upper case and found in the list on the right.

THEME2 = 'AW' and THEME3 = '1'

<boolean>

The database variables are tested against the string constants.

AREA/10000.0

<number>

The value of the database variable is divided by 10,000.

If(AREA<0.5, 0.0, AREA)

<number>

The value of the database variable AREA is tested against a numeric constant. If the value is less than 0.5 then 0.0 is return. If the value is >= 0.5 then the original value is returned.

matches('SW1AW', 'SW.*AW')

true

The string 'SW1AW' is tested against the regular expression 'SW.*AW'. The expression looks for the characters 'SW',followed by anything, followed by 'AW'. Since the first argument matches this pattern, the result is true.

replaceAll('AW/SW', '/', '_')

'AW_SW'

All characters matching the pattern '/' are replaced with '_'.

replaceAll('AW/SW-1', '[/-]','')

'AWSW'

All characters matching the pattern '[/-]' are replaced with ''. This effectively deletes the '/' and '-' characters from the string.

lookupTable(AU, '1,2,3,4,5,6,7,8', 'C,C,CD,CD,DC,DC,D,D')

<string>

The value of AU is found in the first list, and the function returns the corresponding value from the second list. If the value of AU is not found in the first list, then the value of AU is returned unmodified.