Choosing to import files from the Import Text File or Import Spreadsheet dialogs brings up the File Import Properties window below.
The Field (Column) Delimiter specifies how individual values within the data records are formatted. For text files values can be comma separated, tab separated, space separated (free format), character separated, or binary data. When spreadsheets are imported, columns are delimited by Table Cells only.
The Missing Value Indicator specifies the value or character within the file that indicates that a value is missing and that the record should be ignored during importing. A missing value that is imported becomes a blank cell in the GS+ Data Worksheet. The indicator can be absent (specify “None”), a decimal point, a numeric value, or a character.
The Number of Header Records indicates whether the first records in the file contain header records -- descriptive text that should be ignored as the file is read into the Data Worksheet. For text files choose None, Varies, or Fixed Number. Header records will be read into the Data Description field of the Data Worksheet Window. Spreadsheet files are assumed to contain a single header row containing column names.
The Column Title Separator refers to whether column titles (variate names) appear in the second record of the file, and if so, how names are separated from one another within the record. For text files choose No Field Names, Same as for Data Records, Quotes, Brackets, Comma, Tab, Space, or Character. When spreadsheets are imported, columns titles appear in different cells of the first row of the spreadsheet.
Press OK to accept the settings shown and return to the Import Text File or Import Spreadsheet dialog. If the settings are different from the standard settings for the format originally defined, the format will change to Custom with the new settings defining the new Custom format.
Press Cancel to exit the File Import Dialog window and return to the Import Text File or Import Spreadsheet dialog without changing format properties.