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

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Fri, 7 May 1999 09:05:28 -0400
Message-ID: <7guo9c$p6m$1@autumn.news.rcn.net>

Hi,

You can simplify the select statement by changing the column separator character and then doing a straightforward select. e.g.;

    SET COLSEP "*"     SPOOL <file_name>
    SELECT * FROM <table_name>;
    SPOOL OFF     SET COLSEP " " regards

Jerry Gitomer

Prabhakar Narayanan wrote in message <3732956E.674B089B_at_clsasia.com>...
>
>Unfortunately, there isn't an easy way to export the data to delimited
>file. But you can do this
>
>select col1 || '^' || col2 || '^' || col3 || '^' || col4
>from table_name
>
>Spool the output to a file
>Open the file using MS-EXCEL, specify '^' as the delimiter. Excel will
>do the rest for you
>
>Regards
>
>N.Prabhakar
>
>Seigmund Akinwande Johnson wrote:
>
>> Help ,
>> Does anyone know how to do this ?
>
Received on Fri May 07 1999 - 08:05:28 CDT