Copy(data, from, length);

Using the Copy function, you can copy a section of a text.

Example1

The value of the field "Name" is: Rapidi A/S.

 

##COPY("Name", 0, 6) will transfer the first 6 characters from the source field "Name".

Value: Rapidi.

 

##COPY("Name", 7, 9) will transfer characters from position 7 to 9.'

Value: A/S.

 

Example2

In this example the FieldType in the Source and Destination fields does not match:

Source Fieldtype = VarChar: Value = KKK1243000

Destination FieldType = Integer:

 

##COPY(FieldName, 3, 7);

Returns the value = 1243000

which is compatible with the integer datatype.

 

In some cases you need to add a TOINTEGER formula to ensure that values are compared correctly during transfer, or if you need to calculate on the field:

 

##TOINTEGER(COPY(FieldName, 3, 7))