Formula Functions and Operators

Formulas and Operators

Functions and Operators can be used in formulas to manipulate data during transfer.

Operators in formulas

The following Operators can be used:

Operators     Meaning

      +              Add

      -               Subtract

      =              Assign

      *              Multiply

      %             Modulus

      /               Divide

      <              Less than

      >              Greater than

 

Functions 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 field 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". Therefore when specifying the Field List we specify the above line opposite to the destination field "Name".