Functions List (Magic xpi 4.13)

In Magic xpi, you can use functions as part of a condition or a formula for computing a value.

A function usually contains one or more arguments, delimited by commas. The arguments are enclosed in parentheses. Even if the function contains no arguments it still requires a set of parentheses: for example, Date (). Every function returns a value. You can enter any arithmetic expression that follows conventional algebraic rules, or a string or a logical expression.

Operators can be numeric (for example, '+'), string (for example, '&'), or logical (for example, "NOT").

Functions can be nested to any level using parentheses. For example, the following expression gives the real length of the string stored in the variable A: Len(LTrim(RTrim(A))). Further complexity is possible by nesting logical expressions, including IF, AND, NOT, and OR. Magic xpi removes and superfluous parentheses.

A function usually contains one or more arguments, delimited by commas. The argument list is enclosed in parentheses. Even if the function contains no arguments it still requires a set of parentheses: for example, Date ().

Every function returns a value.

Text that is entered for ‘Alpha’ and ‘Blob’ expected output will automatically be surrounded by single apostrophes. For example, if you type some text and click the Verify button, Magic xpi will automatically change some text to 'some text'.

In the Expression Editor, each function has its own tooltip that describes its signature. You can also highlight a particular function in the list, and press F1 to access its Help page.

You can also add user-defined Magic xpa functions to Magic xpi. For more information, click here.

The following is an alphabetical list of functions: