Kbase P111742: IMPORT statement handles blank characters inconsistently
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 8.x
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
IMPORT statement handles blank characters inconsistently
spaces as fields in the middle of the line work correctly:
Example: line with the following fields is read correctly, the second field is read as " " :
aaa, ,ccc,ddd
spaces as last field in the line are ignored.
Example: line with the following fields is read incorrectly, the fourth (last field) is ignored:
aaa,bbb,ccc, (this last field contains spaces before the return characters)
CAUSE:
This is a known issue
FIX:
As a workaround, use quotes for the blank character fields:
aaa,bbb,ccc," " is read correctly.