Functions and Operators can be used in formulas to manipulate data during transfer.
The following Operators can be used:
Operators Meaning
+ Add
- Subtract
= Assign
* Multiply
% Modulus
/ Divide
< Less than
> Greater than
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").
##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".