---
title: "COPY"
description: "COPY"
keywords: "COPY MINIMUM MAXIMUM FIELD LENGTH"
url: "https://myrapidi.com/wiki/copy"
locale: "en"
published: "2009-05-15T06:41:15Z"
modified: "2024-09-27T16:05:17Z"
---

# Copy(data, from, length);

Using the Copy function, you can copy a section of a text by specifying the minimum and maximum of that value. This formula is useful when you have a field length limitation in the destination system.

 

**Example 1:**  
  
The value of the field " **Name**" is: **Rapidi A/S**  
  
`##COPY("Name", 0, 6)`  
  
It will transfer the first 6 characters from the source field " **Name**". And the result value will be **Rapidi** ( since length is set up to a maximum of 6 characters.  
  
`##COPY("Name", 7, 9)`  
  
It will transfer characters from position 7 to 9. In this scenario, the result value will be **A/S** since the length is between the last 7 and 9 characters. 

**Example 2:**

> In this example the FieldType in the Source and Destination fields does not match:Source Fieldtype = VarChar: Value = KKK1243000Destination FieldType = Integer: ##COPY(FieldName, 3, 7);Returns the value = 1243000which 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))

**Example 3:**

>  The formula ##COPY("BillingCity",0,29) will transfer the first 29 characters from the source field "BillingCity".