Kbase P4068: How to export or import TAB delimited data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/30/2008 |
|
Status: Verified
GOAL:
How to export or import TAB delimited data
GOAL:
How to use TAB as a delimiter for the EXPORT and IMPORT statements.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The TAB character can be referenced with an escape character expression.
The TAB character is represented: ~011.
Example 1 -- Exporting:
OUTPUT TO file.txt.
FOR EACH customer:
EXPORT DELIMITER "~011" customer.
END.
OUTPUT CLOSE.
Example 2 -- Importing:
INPUT FROM file.txt.
REPEAT:
CREATE customer.
IMPORT DELIMITER "~011" customer.
END.
INPUT CLOSE.