Kbase P98776: How to import a delimited file from 4GL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/12/2004 |
|
Status: Unverified
GOAL:
How to import a delimited file from 4GL?
FIX:
The following example shows how to import from a text file into a Temp-Table data delimited by char "@".
DEFINE TEMP-TABLE foo FIELD a AS CHAR FORMAT "X(25)" FIELD b AS CHAR FIELD c AS CHAR
INDEX x a DESC b DESC c DESC.
INPUT FROM C:\aaa.txt.
REPEAT:
CREATE foo.
IMPORT DELIMITER "@" foo.
END.
INPUT CLOSE.
FOR EACH FOO:
DISPLAY FOO.
END.
Where aaa.txt contains the following information
REJILLAS TIPO "A"@DATO1@DATO2