Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lost last space
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
![]() |
![]() |