Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Lost last space

Re: Lost last space

From: gazzag <gareth_at_jamms.org>
Date: Thu, 08 Nov 2007 14:09:02 -0800
Message-ID: <1194559742.037857.57530@i38g2000prf.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

I've just re-read your post. CSV stands for Comma Separated Values. i.e. Each field is delimited by a comma (","). Do I understand you correctly?

-g Received on Thu Nov 08 2007 - 16:09:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US