|
ANSI Description page (Import File Description wizard) |
|
Use this page to specify the format and delimiting characters for importing ANSI files.
Check this box to specify that the first line in the import file is a header.
 | Selecting this option will map every field in the first line of the import file to column labels. |
Refer to the Label Column command for additional information on column labels.
Check this box to specify you want to force all field values to text.
| This option is necessary for instances when a text value erroneously maps to another type. Consider, for example, the case of importing a file with customer id numbers in the form ####, where # is a digit and where leading zeros are significant. To avoid a numerical interpretation of these values (and consequential removal of the leading zeros), you would resort to this option. After completing an import process with this option, you would typically proceed to remove the forced text condition from the other cells, or range of cells, that do not require it with the Remove Forced Text command. |
Row Boundary
Select from this list the character, or sequence of characters, used to delimit lines (rows) in the import file.
Select this option to specify that the line boundary is indicated by the carriage return character, CR.
Select this option to specify that the line boundary is indicated by the line feed character, LF.
Select this option to specify that the line boundary is indicated by the carriage return character, CR, followed by the line feed character, LF.
Select this option to specify the line boundary is indicated by some other character, or sequence of characters, not in this list.
Click this button to display the Boundary Specification dialog box to specify the character, or sequence of characters, that delimits a line.
Select this option to specify that lines in the import file are delimited by a fixed number of characters. When you select this option, you have to type the number of characters that make up one line in the box to the right of this option.
Column Boundary
Select from this list the character, or sequence of characters, used to delimit line fields (columns) in the import file.
Select this option to specify that the field boundary is indicated by the space character.
Select this option to specify that the field boundary is indicated by the horizontal tab character.
Select this option to specify that the field boundary is indicated by either the space character or the horizontal tab character.
Select this option to specify that the field boundary is indicated by some other character, or sequence of characters, not in this list.
Click this button to display the Boundary Specification dialog box to specify the character, or sequence of characters, that delimits a field.
Select this option to specify that fields in the import file are delimited by a fixed number of characters. When you select this option, you have to type the number of characters that make up one field in the box to the right of this option.
Consecutive Boundary Treatment
Select from this list a policy for when consecutive boundary characters, with no information between, are found in the import file.
Select this option to specify that empty lines and empty fields should be skipped.
Select this option to specify that empty fields should be set to zero.
Select this option to specify that empty fields should be created and left empty.
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support