Re: HELP (How to export a table to a delimetered text file)

Without using a report-writer ( like Crystal) you need to

spool the output to a file

Use a
Select rtrim(field_1)||','rtrim(field2)||','........

In other words, concatenate the field name with the delimiter character ---

Check the options regarding
set feedback off, verify off, line size, pagesize etc... to keep the output file as clean as possible, otherwise you'll need to do some editing before using the file....

With a report writer ( or something like Access) you can export the data in delimited format....much easier....

Hope it helps,

"Seigmund Akinwande Johnson" <asjohns_at_midway.uchicago.edu> wrote:

>Help ,
>Does anyone know how to do this ?
>
>

To reply by Email please remove the 'nospam' part of the address Received on Mon Apr 26 1999 - 14:02:32 CDT