Export Template Expressions

This page includes a listing of all expressions currently available, along with syntax and examples for each.  

Notes:
-- Literal values are defined by any value placed within double quotes (a, 4, etc.).

-- In general, numeric values do not need to be enclosed in double quotes.

-- A database field is defined as any valid field that the export/extract process understands.  Users can look at the drop-down list of valid fields in the Expression Wizard when building expressions to see appropriate values.  If you create an expression with invalid database fields, the system will give you an error explaining which field is not correct.

-- Nested expressions are expressions inside of other expressions.  Some expressions cannot be nested, that is, they cannot be included inside another expression.  This is indicated for each expression below.

-- White space and carriage returns are allowed when constructing an expression to allow for improved readability.

 

Click on a link below to learn more about a particular expression.  See the example template below which also has a number of expression examples.

APPEND

AUTOHEADER

CONCAT

DATE

DATEMATH

FIELD

FIELDSUM

FIRSTVALUE

!HALT!

HIDE  

IF

IFZERO

!IGNORERECORD!

LENGTH

MATH

!NEWLINE!

NUMBER

POST

PROPERTY

RECORDCOUNT

Run Time Parameter

SEQUENCE

!SKIPRESTOFLINE!

SUBSTR

SUM

SWITCH

TIMEQUANTITY

 

Example Expressions

Note: The NUMBER format option can also be used with negative values: e.g. NUMBER(##0.00;-##0.00) IFZERO("")

Here are some examples: