This dialog box is used to import data from one or multiple text files into
one or multiple data tables or into a single data
sequence.
The grid control in this group box can be used to specify the data files
whose data need to
be imported. Double clicking a cell under the Source Path column opens the File Open dialog box with which the user can browse
the data files. The values in the cells under the Persistence column
determine the data persistence modes (i.e. Embedded or Linked)
for the files.
Import file(s) as a data sequence
Check this check box to import the data in the files into a data sequence.
Auto skip header lines
Check this check box to have DataScene automatically skip header lines.
If both this check box and the Delimited columns check box are
checked, DataScene will use the data in the last row of the data file to
determine the number of header lines to skip; if both this check box and the Fixed-width columns
check box are checked, DataScene will skip all header lines in the data file
whose widths are smaller than the specified column width.
First line as column names
Check this check box to read column names from the first
lines of the files.
Number of header lines to skip
This text box is enabled only if the Auto skip header lines check box is
not checked. The value in this text box specifies the number of header lines to skip.
Delimited columns
Check this radio button if the columns in the data files are delimited by a
specific delimiter.
Fixed-width columns
Check this radio button if the columns in the data files are of fixed
widths.
Delimiters/Format
This combo-box is enabled only if the
Delimited columns radio button is checked. The value in this combo-box specifies
either the column delimiter(s) or the file format. The user
may select one of the pre-defined delimiters or directly type in one or
multiple custom delimiters into this combo-box.
If CSV Format is selected, the input files are treated as in the
Comma Separated Values (CSV) format.
Number of columns
This text box is enabled only if the Fixed-width columns radio
button is checked. The value in this text box specifies the number of data columns in the
data files. Use the grid
control beneath this text box to specify the individual column widths.
