Kbase P112457: IMPORT 4GL statement reading text file skips minus hyphen '-'
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/11/2006 |
|
Status: Unverified
SYMPTOM(s):
IMPORT 4GL statement reading text file skips minus hyphen '-'
Importing a text file that includes records with a hyphen (-) are skipped.
CAUSE:
The file contains and unquoted hyphen which causes its corresponding field to be skipped. This is expected behavior.
From the IMPORT statement on line reference entry:
If an input data line contains an unquoted hyphen in place of a data value, then the corresponding field is skipped, as it is in UPDATE. If you specify a hyphen (-) as the delimiter character, all hyphens are treated as delimiters. If you use the UNFORMATTED option, the hyphen is treated the same as any other character.
FIX:
Enclose the hyphen in quotes or use the UNFORMATTED option.