Functions

double Sine (double angle)

// angle in degrees

double Cosine (double angle)

// angle in degrees

double Tangent (double angle)

// angle in degrees

double Acosine (double value)

// result in degrees

double Atangent (double value)

// result in degrees

double Sqrt (double value)

// square root

double Log10 (double value)

// base 10 logarithm

double Logarithm (double value)

// natural logarithm

double Alog10 (double value)

// base 10 antilogarithm

double Alogarithm (double value)

// natural antilogarithm

double Absolute (double value)

// absolute value

integer Fix (double value)

// rounded towards zero

integer Ceiling (double value)

// rounded up

integer Round (double value)

// nearest integer

double Atant (double x, double y)

// atan of x/y (degrees)

double Minimum (double a, double b, …)

// minimum value

double Maximum (double a, double b, …)

// maximum value

integer Length (string text)

// number of characters

integer Occurs (string text, string sub)

// number of occurrences of sub in text

integer Instring (string text, string sub)

// Position of first occurrence of sub in text

string Asstring (object value)

// convert numeric or Boolean value to a string

double Asreal (object value)

// convert string value to a double

boolean Asboolean (object value)

// convert string or number value to a Boolean

string Substring (string text, integer start [, integer length])

// substring from the start position of given length (or to end of text)

string Left (string text, integer length)

// left part of text

string Right (string text, integer length)

// right part of text

string Before (string text, string sub)

// left part of text before given substring

string After (string text, string sub)

// right part of text after given substring

string Uppercase (string text)

// convert to upper case

string Lowercase (string text)

// convert to lower case

string Replace (string text, string seek, string sub)

// replace all occurrences in text of substring seek with substring sub

string Trim (string text)

// remove leading and trailing white space from text

string Format (string pattern, object
arg1, …)

// substitute the values of the arguments into the pattern string

  - details of this are given below

string Lookup (string dictName, string key)

// return the value associated with the key in the given Dictionary

  (refer to Dictionaries section)

boolean Like (string pattern, string text)

// test if the text conforms to the wildcard pattern. Wild characters are:

* - matches any number of characters

? - matches any single character

boolean Between (object test, object
lower, object upper)

// determine if the test object lies between the given lower and upper values.

Arguments may be all numerical or all alphanumeric.

boolean Inlist (object test, object
value1, …)

// determine if the test equals one of the given list of values.

Arguments may be all numerical or all alphanumeric.

Integer Listposition

// the list order position of the current target element.

in the members list of its owner.