Kbase P36174: Importing from a text file does not get all the expected records!
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/08/2004 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Trying to import records and doesn't get all of the requested records.
CAUSE:
The file was corrupted by including multiple instances of the null character CHR(0).
FIX:
Remove the null characters using the UNIX command utility:
tr -d '\000' <corrupted.txt >cleaned.txt
and do the importing from the resulting cleaned up file.