|
<< Click to Display Table of Contents >> Navigation: General Functions > Import / Export > Export > Setting up an Export Job > Fixed Length Field Definition |
Fixed length field files are still used by some older systems. The system does not expect delimiters to mark the beginning and end of each field. Instead, the system expects each field to be contained within a fixed length column. The MIE can write files that can be imported by these older systems.
After initially selecting a fixed field length export from the first wizard screen, the definition of each field is performed on the second screen of the wizard. The following settings are available:
Setting |
Definition |
Source Field |
Choose a field from the list. This list is read from the header record in the import file specified in the previous step of the wizard. Either choose a field to import, or select -Ignore- to insert a constant. |
Constant |
If -Ignore- has been chosen for the source field, then enter the constant value in this column. The value must agree with the destination field data type. For instance, do not enter an alpha constant that is destined for a numeric field. |
Transform |
Choose --> (no transformation) or one of the data transformations. Transform will perform the specific transformation on the data before writing it to the destination field. |
Pad With |
If not left blank, then any non-data positions in the field will be padded with this character. For instance, if the field alignment is Right, and the data to be written to the field is 24, and the field Length is 8, and the Pad With character has been defined as 0, then 00000024 will be written to the field. |
Align |
Defines how data will be aligned within the fixed column width. |
Length |
Defines the fixed width of the column (field). |