Import Table wizard |
Main window, File menu |
View File (ASCII tables only) |
< Back | Next > |
Note: This page is only shown when you are importing:
When importing a dBase DBF file, this page is skipped; you can click Next at the top of this page.
Page options:
The first 100 lines of the ASCII file are shown in a list box.
You can use this page to inspect the contents of your ASCII table.
If you wish to change the format that should be used to import the file, click the Back button; on the Select Table Format page, select another format; then click the Next button to return to this View File page again.
After clicking the Next button, the Import Table - Edit Column Details can be used to specify the name and type of domain for each column, and, optionally, specify a domain for the table.
ILWIS 1.4 format:
A file that is in ILWIS 1.4 table format may look like:
|
col1# col2$ col3% col4& #1 |
|
45 abc 999 0.045 |
|
44 defghij 25 0.061 |
|
48 xxyyz 31 0.075 |
The first line is a header which defines the column types, and sets the record numbers:
|
colname$ |
column stores any strings or characters |
|
colname# |
column stores byte values (whole positive numbers between 0 and 255) |
|
colname% |
column stores integer values (whole numbers between -32766 and 32767) |
|
colname! |
column stores long integer values (whole numbers between - 2 billion to 2 billion) |
|
colname& |
column stores real values (values with decimals) |
|
#number |
the offset of the record numbers in the table, #1 means that the first record is record number 1. |
In a record, a field is separated from a next field by a space.
Comma delimited format:
A file that is comma 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 a comma.
Space delimited format:
A file 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 file 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 - Edit Column Details
Appendices : ILWIS script language (syntax), section ILWIS Table import