Data Format Type Settings Data Format > Type |
![]() ![]() ![]() |
The Type tab defines the syntax of the data file. Delimited text files Select Delimited if the fields are separated by a delimiter character such as a tab or comma. Mark the Detect checkbox to have the program automatically determine the delimiter. Otherwise, specify the delimiter character(s) and select the Text qualifier that optionally surrounds fields (necessary for data that contains the delimiter character). Mark the Treat consecutive delimiters as one checkbox if a delimiter can consist of multiple delimiter characters. For example, if the data file contains columns separated by whitespace, you should enable this option and select Space as the delimiter character. Unmark the Treat surrounding whitespace as part of delimiter checkbox if any whitespace next to a delimiter should be considered part of the data field. Fixed position text files Select Fixed for files where fields are defined by position on the line. Enter the Column widths in a list separated by semicolons. All types Select the Decimal symbol to be used when interpreting numeric fields. Normally the symbol set by your system's Regional Settings is used but you can override it here. Often, the first line of a data file is a header, containing the names of the columns. The First line contains option controls whether the first line is a header or a regular data row. Select Detect to have Data Compare try to determine it automatically. |