6.7 Partial Importing and Re-Importing


Video Image.png See more related video:Partial Import

Partial Import

When you need to import only part of a data file -- for example, the file contains data that is of no interest or the file is large and slow to import -- you can opt for a partial file import.

  • When importing via Data: Import from File, Origin supports partial import for ASCII, binary (using Import Wizard), comma-separated (CSV), MS Excel and third-party files of types pCLAMP (ABF, DAT) and Sound (WAV).
  • When importing via Data Connector (Data: Connect to File), you can set up partial import of CSV files.
  • The CSV Connector shows only Column and Row controls. Follow the syntax and examples described under Partial Import Controls > Custom, below, for guidance with the CSV Connector.

When you have imported data with the CSV Connector, you can hover on the Connector icon to see which portion of your data have been imported.

Partial import csv on hover.png

Partial Import Controls

Partial Import controls for most file types look similar to those shown in the following image and described in the table below.

Partial Import.png
From and To Specify the start and end column index which will be imported.
Read and Skip When you specify a number l for Read and a number k for Skip, l columns are imported and k columns are skipped for every l+k columns.
Custom Use the following characters in building your import string:
  • space ( ) = "and".
  • colon(:) separates From and To.
  • vertical bar(|) = "read n cols/rows".
  • dash(-) = "skip".
  • tilde(~) = "except".
Examples
1 3 7 import cols/rows 1,3 and 7.
1:100 ~50:60 import cols/rows from 1 to 100, except 50 to 60.
1:200|3-2 import cols/rows from 1 to 200 by reading 3 then skipping 2.
1:1000 ~200:300 250:260 import cols/rows 1 to 1000, skipping 200 to 300 with the exception of 250 to 260.
1:100|3-7 5:100|2-8 imports cols/rows 1 to 100, read 3 then skip 7 and import cols/rows 5 to 100, read 2 then skip 8. The "and" (space) combination generates a repeating pattern of read 3, skip 1, read 2, skip 4 for every 10 cols/rows.

Not all the import tools support Partial Import

Re-Import

Re-importing, as the name suggests, allows you to repeat the import of a file that has been imported previously. You may want to use this feature when the imported file has been updated -- direct import with no change of options -- or you want to use different import options. Both are performed via menu commands on the File: Import menu. The re-importing feature is available for ASCII and some third-party files.