Import ASCII files

This dialog is activated by selecting the command Import -> Import ASCII...from the File Menu. It can be used to select several files at a time. The files are imported using a set of default options. You can display and edit these options by pressing the Advancedbutton. All your changes to the default import parameters will be saved.

Figure 5-63. The dialog box.

You can define a custom file filter in the Files of type: field in order to preselect files (e.g. typing *.mydata then "Enter" so that only files XXX.mydata are listed in the directory view).

Concerning the separator which is used between the columns, you must bear in mind that there is no grouping of separators, so if you use "SPACE", you must use only one separator between each column or check the Simplify white spaces option.

If your data files have a particular structure, for example if they present several lines containing the description of your experiment, before the actual data start, you have the possibility to skip the n first lines of the file. You can also skip all lines starting with a comment character/string. The comment string can be customized via the text edit line Ignore lines starting with.

If you choose to use the first line as column names and/or the second line as comments to be displayed in the table header, you must use the same separator between the column names and between the data columns.

Assuming that the data files you want to import were created using different decimal separator conventions than the ones you're using, like for example a comma character for the decimal point instead of a dot character, you have the possibility to convert the data to your current settings, by specifying the Decimal Separators convention used in the ASCII files in conjunction with the Omit thousands separator option.

Finally, you can specify the kind of data to be imported in each column by pressing the Column Types... button or by clicking on the column header in the preview table. A dialog will pop-up allowing you to choose a data type (the default data type for each column is Numeric) and a column format for date/time columns.