When importing from text file it is supposed that every table record is located in a separate line of file.
The system supports import from text files of two basic formats: with separators and with fixed field width.
Setting import serves for refining characteristics of input text file (table 73-1) and specifying table fields to which data should be imported.
File characteristics | Description |
Fixed | Every field in text file should have some fixed width. |
With separators | Field width is arbitrary, but fields should be separated by some separator character which can be specified by the user. As a rule a tab, a semicolon or a comma are used as such a separator character. |
Separator | A separator character of fields for format of text file with separators. |
Field names | The line containing field names of the table being imported can be present in the input file. |
Coding | Different coding of characters is used in DOS and Windows operating systems. To provide the possibility of reading the file in required system one should select the necessary coding of characters. |
Quote strings | In format of file with separators inverted commas are often used to single out strings. |
Date format | To display date it is possible to use various formats: the order of date parts – day, month, year; method of writing month; separator of date parts, etc. |
Format of Boolean values | To denote Boolean values “True” and “False” several variants can be used. |
Table 73-1. Text file parameters
 |  |
