CSV output for a temp-table

make

Member
Hi,
i have build a temp tabel with some fields. No i want to make an output to a csv file.
Can anybody give me a tip, maby with short example ?

greets
Make
 

Crittar

Member
Make sure that none of the fields on your temp-table have a format which would include commas.

Then simply:

OUTPUT TO /somewhere/somefile.csv.

FOR EACH temp-table NO-LOCK:

EXPORT DELIMITER ',' temp-table.

END. /* End for each */

OUTPUT CLOSE.

Simply replace "/somewhere/somefile.csv" with the path and name of the file you want; replace "temp-table" with the name of your temp-table.

Hope this helps.

:awink:
 
Top