Kbase P126970: How to use TAB delimiter character on the Quoter
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2011 |
|
Status: Unverified
GOAL:
How to use TAB delimiter character on the Quoter
GOAL:
How to use Quoter with TAB delimited data files: UNIX example
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
The quoter utility supplied with PROGRESS can be used to reformat data files where the TAB character was used as a field delimiter. Use the syntax shown below to process the file prior to loading.
In the following example, the data file "cust-tab.d" would be the data file from the source application which used the tab character as a field delimiter; the "cust-quoted.d" file would be the resulting PROGRESS-format data file:
UNIX VALUE ('quoter -d "' + chr (9) + '" cust-tab.d > cust-quoted.d').
OR
UNIX quoter -d "'~t'" cust-tab.d > cust-quoted.d
The OS-COMMAND statement can be used in place of the UNIX statement for other operating systems.