Re: 'Carriage Return' in spool file

Tse <tcng_at_yas.com.sg> wrote in message news:7lcors$ce3$1_at_nobel2.pacific.net.sg...
> Hi,
>
> Whenever I do a select and spool the result to a file in sqlplus on the Unix
> server, the length of each row of data is fixed as the 'linesize'. (All rows
> of records have a fix length = linesize.)
>
> How do I put a Carriage Return at the end of each line so that there is no
> whitespaces after the last field? Which means that now the size of each
> record will be different from the others depending on the size of each field
> that makes up the row.
>
> The field delimiter is the double quote(") and the field seperator is a
> comma(,).

You can use:

    set trimspool on Received on Fri Jul 02 1999 - 20:20:41 CDT