Details on Import Settings


  1. Select File > Open....

  2. Browse to a delimited text file and click Open.

load_import_settings_d.png

Option

Description

Separator character

Allows you to specify which character to interpret as separator character.

Individual fields (column names, type strings, and values) are delimited by separator characters—usually commas, semicolons or tabs. Spotfire automatically makes a guess to determine the separator character, but you can change to a different separator character if necessary.

Culture

Allows you to change the culture (the language-related regional settings for formatting information, such as time, currency, or dates) from which the data originates.

Encoding

Allows you to change the encoding used to interpret the data.

Advanced...

Opens the Import Settings – Advanced dialog, where additional settings can be changed.

Refresh

Updates the Data preview field to reflect any changes made to the settings in this dialog or the Import Settings - Advanced dialog.

Data preview

Shows how the file will be interpreted, given the specified settings.

     Name

Double-click on a column name to edit the name.

     Type

Change the type for a column by clicking on the arrow and selecting the new type from the drop-down menu. The available data types are: String, Integer, Real, Currency, Date, Time, DateTime, TimeSpan, LongInteger, SingleReal and Boolean.  If an inapplicable data type is selected, the data in the preview will be displayed in italics once you have clicked on the Refresh button.

     Included

Clear the check box to ignore a specific column upon import.

 

The drop-down list available on each row contains the following options:

Option

Description

Name row

Select this option on the row or rows that will be used to specify the column names in the imported data.

Type row

Select this option on the row that will be used to specify the data types.

Data row

Select this option for all data rows that you wish to import.

Ignore

Select this option for rows that should be ignored during import.

See also:

Opening a Text File