Field Expressions

Output field name attributes

Output field name attributes can now be used in field expressions. For example, the expression below will "high cut" the AU field and output the kriged value to an AU_CUT field. The ?[<name>] prefix indicates an output field name attribute:

=?[AU_CUT] CUTHIGHS([AU], 6.0)

Create Filter: Expression Mode.

File filters can now be created in Classic mode or Expression mode:

Classic mode, uses the fields, operators and values specified in a Filter Conditions grid. In Expression mode, filters are evaluated using the rules and precedences that apply to field expressions:

File | Fields | Calculate Expression

Numeric Exceptions are now optional when field calculations are created with expressions.

Note that the Ignore blanks check box in the Numeric Exceptions dialog is now selected by default. Blank field values encountered in an expression may produce unexpected results. In most calculations it also makes sense to treat blank values as null values and ignore them.

Range Checks

Support for range checks using two comparison operators has been improved and take the form:

(expr) (comparison operator1) (expr) (comparison operator2) (expr)

Where both comparison operators are less than (or equal), or greater than (or equal), but not both.

For example: 2<x<3 returns true if x is greater than 2 but less than 3

For more information, see: Expression Editor

New number formatting, text formatting, and text substring functions are now available for selection in the Expression Editor.

Wildcard Matching

New functions to match a string to a wildcard or regular expression have also been added, which can be used to select a subset of data for conditional calculations, ad hoc wireframe sets, and filters, for example:

For more information, see: Functions

Date Conversions

New date and time functions are now available for selection in the Expression Editor. New date formats can be parsed and old-style date formats can be converted using a new PARSEDATE_ADV(str, format) function. For example:

PARSEDATE_ADV("19/08/02","YYY/MMM/dd")

For more information, see: Date format conversion