Kbase P178417: IMPORT command is not import all data from file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/12/2010 |
|
Status: Unverified
SYMPTOM(s):
IMPORT command is not import all data from file
Only partial value is imported
Using non-default delimiter
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
Because file is using a non-default delimiter the AVM is unable to determine when value ends and another begins
FIX:
Use DELIMITER option with IMPORT command.
E.g: The sample code below uses a coma as delimiter
INPUT FROM file.txt.
REPEAT:
CREATE customer.
IMPORT DELIMITER "," customer.
END.
INPUT CLOSE.