Function Reference Guide

Text Replace Rules/ Transformations

ORIGINAL

No transformation applied output as stored data

LEFT

Returns the designated number of text characters, starting from the left

MIDDLE

User defines a start character number (from the left) and a number of characters to be returned from this start point.

RIGHT

Returns the designated number of text characters, starting from the right

FIND

Find and Replace, user defines a string value to be identified, plus a replace value (this can be blank)

REGEX REPLACE

Text that matches the regular expression will be replaced with the defined replace value (this can be blank). Regex Replace will adhere to either full match, or if groups are part of the expression (in parentheses), Group 1 match only.

REGEX EXTRACT

Text that matches the regular expression will be returned. Regex Extract will adhere to either full match, or if groups are part of the expression (in parentheses), Group 1 match only.

Number Transformations

ORIGINAL

No transformation to the store value.

ADD PERCENTAGE

The original value plus the defined percentage of that value.

ADD ABSOLUTE

The original value plus an absolute number value

SUBTRACT PERCENTAGE

The original value minus the defined percentage of that value.

SUBTRACT ABSOLUTE

The original value minus an absolute number value

FORMULA

User can define a formula using # to represent the stored number variable. Accepted operators are:

Add +

Subtract –

Divide /

Multiply *

Parentheses can be used

e.g. (#+2)*3

Note: For all number transformations, the returned value will have the same number of decimal places as the original store value.

Text Match Condition Functions

IS BLANK

Variable is null

IS NOT BLANK

Variable is not null

CONTAINS

Variable contains defined string

DOES NOT CONTAIN

Variable does not contain defined string

STARTS WITH

Variable starts with the defined string

DOES NOT START WITH

Variable does not start with the defined string

ENDS WITH

Variable ends with the defined string

DOES NOT END WITH

Variable does not end with the defined string

MATCHES

Variable exactly matches the defined string

DOES NOT MATCH

Variable does not exactly match the defined string

REGEX MATCH

Variable matches the defined regular expression

Number Match Condition Functions

IS BLANK

Variable is null

IS NOT BLANK

Variable is not null

GREATER

Variable is greater than the defined number value

GREATER OR EQUAL

Variable is greater than or equal to the defined number value

LESS

Variable is less than the defined number value

LESS OR EQUAL

Variable is less than or equal to the defined number value

EQUAL

Variable is equal to the defined number value

NOT EQUAL

Variable is not equal to the defined number value

BETWEEN

Variable is between the two defined number values

NOT BETWEEN

Variable is not between the two defined number values