6.4.8.6 Import Wizard, The Data Selection Page (ASCII Binary)

Use this page to specify a partial file import, and other data handling instructions.

Data Selection Page ASCII Binary.png

Contents

Partial Import

Partial Import

This drop-down list has three options: None, All Files and From 2nd File On. The All Files and From 2nd File On option will enable From/To Column and From/To Row ranges for partial import.

  • None : Disable the partial import settings.
  • All Files: Apply the partial import settings for all selected files.
  • From 2nd File On: Apply the partial import settings for all selected files except the 1st file.
From/To Column

Enter two column numbers to specify the column range for partial import. The default From and To settings are 1 and 0 respectively (which will result in all columns and rows being imported).

From/To Row

Enter two row numbers to specify the row range for partial import. The default From and To settings are 1 and 0 respectively (which will result in all columns and rows being imported).

Skip Columns

Skip columns must be an integer value greater than or equal to 0. If Skip Columns = 0, no columns are skipped on import.

Read Columns

This text box is only editable when Skip Columns is not zero. It must be an integer value greater than or equal to 1.

If Skip Columns > 0, then the Import Wizard repeats importing Read Columns column(s) and skipping Skip Columns column(s) until the end of the file or Partial Import range settings are satisfied.

Skip Rows

Skip rows must be an integer value greater than or equal to 0. If Skip Rows = 0, no rows are skipped on import.

Read Rows

This text box is only editable when Skip Rows is not zero. It must be an integer value greater than or equal to 1.

If Skip Rows > 0, then the Import Wizard repeats importing Read Rows row(s) and skipping Skip Rows row(s) until the end of the file or Partial Import range settings are satisfied.

Apply

Click this button to apply the range settings.

Non-Numeric Data in a Numeric Field Controls (ASCII Only)

This is only available for ASCII files. If non-numeric data is interspersed with numeric data, you can use this control to decide what action should be taken when non-numeric data are encountered (typically, such non-numeric data is used to identify and separate various datasets in a file).

This drop-down has four options:

Terminate Import

Import will be terminated when the first non-numeric data item is found within the data.

Skip

Non-numeric data will be skipped (see Read as Text).

Read as Text

Non-numeric data will be read in as text. If the column Format is set to Text & Numeric, the text will be visible in the resulting worksheet page. If the column Format is set to Numeric, the text will display as missing values.

Start new (hidden) book

A new hidden workbook is started if non-numeric data are encountered.

Start new worksheet

A new worksheet is started if non-numeric data are encountered.

Start new column

A new column is started in the same worksheet if non-numeric data are encountered.

Column Preview Window

This window displays the imported data as it will look in the resulting worksheet. Note that you can right-click the title of each column and set its format and destination with the short-cut menu.