...
Option | Description |
|---|---|
Name | Name of the field |
Type | Type of the field can be either String, Date or Number |
Format | See Number Formats for a complete description of format symbols. |
Position | This is needed when processing the 'Fixed' filetype. It is zero based, so the first character is starting with position 0. |
Length | For Number: Total number of significant figures in a number; For String: total length of string; For Date: length of printed output of the string (e.g. 4 only gives back the year). |
Precision | For Number: Number of floating point digits; For String, Date, Boolean: unused; |
Currency | Used to interpret numbers like $10,000.00 or E5.000,00 |
Decimal | A decimal point can be a "." (10;000.00) or "," (5.000,00) |
Grouping | A grouping can be a dot "," (10;000.00) or "." (5.000,00) |
Null if | Treat this value as NULL |
Default | Default value in case the field in the text file was not specified (empty) |
Trim | type trim this field (left, right, both) before processing |
Repeat | If the corresponding value in this row is empty, repeat the one from the last row when it was not empty. |
...