Copy From

With this function data from one field is written to the next record of another field. If you use the increment option then all fields are incremented by this amount before being copied.

This makes it very useful for automatically entering all values in the From and To fields of a drillhole sample. For example, by entering only the source (From Field) and destination (Field Name), data will be copied from the source to the next record in the destination. You can also give the first record in the destination field a value, by specifying it in the start field.

Note that you cannot use this to make a straight copy (into the SAME record) from one field to another. See Split and Calculate.

With the Copy From function all parameters are optional (except the Field Name and From Field).

To use the copy option, follow these steps:

  1. On the File tab, in the Edit Data group, select the Fields | Increment option.

  2. Enter the name of the file you want to work with. Optionally define a filter to selectively control which records will be processed.
  3. To overwrite existing data in the file, select the Overwrite Data box, otherwise the function will only work on blank records.
  4. If the Skip Records field contains a value, the Copy From value will be copied an additional number of lines below the Skip Records value.
  5. In the column called Field Name, type the name of the field you want to copy to.
  6. From the Function list, select Copy From.
  7. In the From Field enter the name of the field you want to copy from.
  8. If you want to write a value to the first record of the destination field, enter it in the Start field. (Unlike Increment or Replicate, the value is written to the first record only.)
  9. If you want to combine copy and increment, enter a value in the Increment field. Values from the source field will then be incremented with this value before they are written to the destination field.
  10. Click OK.