Functions and Operators

Funtions and Operators can be used in Formulas to manipulate data during transfer.

Operators in formulas

The following operators can be used:

Operators:

+ means Add

- means Subtract

= means Assign

* means Multiply

% means Modulus

/ means Divide

< means Less than

> means Greater than

Funtions in formulas

The following functions can be used:

NOTICE THAT When specifying constants of the type text, you have to specify a ' sign at the beginning and at the end of the text (for example: 'Name').

If any special signs occur in tield names, such as a blank, you have to use the " sign at the beginning and end at the field name (for example: "Field Name").

When the value of two fields should be inserted in one field:

##Firstname + ' ' + Lastname;

In a situation where the value of two fields should be inserted in one field when data is transferred, you can use the above line.

For example, in the source table we have the fields "Firstname" and "Lastname" and in the destination table first and last name are specified in one field, "Name". Therefore when specifying the Field List we specify the above line opposite to the destination field "Name".