Re: Lost last space

From: gazzag <gareth_at_jamms.org>
Date: Thu, 08 Nov 2007 14:05:19 -0800
Message-ID: <1194559519.624611.112780@e34g2000pro.googlegroups.com>

On 8 Nov, 20:13, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> I have a table with the last column
> with only one space
> I try to generate a CSV
>
> set colsep '$'
> set linesize 500
> => a lot of space at the end of record
> set trimspool on
> => no space at the end of a record
>
> How can I get a CSV
> with exactly one space at the end of a record ?
> (as it is in the table)
>
> Thanks for your help

SQL> SET COLSEP , Note: "," instead of "$" with no quotation marks

HTH -g Received on Thu Nov 08 2007 - 16:05:19 CST