Select the format of the table you wish to import. The dBase DBF format, the ILWIS 1.4 table format and the Comma delimited format are automatically recognized.
Page options:
|
 dBase DBF:
|
The file to be imported is a binary file in dBase format;
required extension .DBF
|
|
ILWIS 1.4:
|
The file to be imported is an ASCII file in ILWIS 1.4 table format;
default extension .TBL, any extension allowed.
|
|
Comma Delimited:
|
The file to be imported is an ASCII file;
any extension allowed;
in a record, fields are separated by a comma.
|
|
Space Delimited:
|
The file to be imported is an ASCII file;
any extension allowed;
in a record, fields are separated by (at least) one space or (at least) one tab.
|
|
Fixed Format:
|
The file to be imported is an ASCII file;
default extension .SDF, any extension allowed;
in every record, a certain field starts at the same specific position.
|
When you specify to import a file in ASCII format (ILWIS 1.4, Comma delimited, Space delimited, or Fixed format), and click the Next button, the Import Table - View File page will appear. On that page, the first 100 lines of the file will be displayed, so that you can see whether the file to be imported has a header that should be skipped, and where you can inspect the structure of the file.
When you specify to import a file in dBase format, and click the Next button, the Import Table - Edit Column Details page will appear directly.
Additional information
Space delimited format:
A files that is space delimited may look like:
|
1 45 abc 999 0.045
|
|
2 44 defghij 25 0.061
|
|
3 48 xxyyz 31 0.075
|
In a record, a field is separated from a next field by (at least) one space or (at least) one tab.
Fixed format (Standard format):
A files that is in fixed format (also called standard format) may look like:
|
1 45 abc 999 0.0450.4
|
|
2 44 defghij 25 0.0610.5
|
|
3 48 xxyyz 31 0.0750.7
|
In every record, a certain field starts at the same specific position. Positions without information are supposed to be filled with spaces.
As you can see, subsequent fields are not necessarily separated from one another by a separator (last 2 'columns').
See also:
Import Table - View File
Import Table - Edit Column Details
How to import data
Appendices : ILWIS script language (syntax), section ILWIS Table import