Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Whitespace question
That works just great!
A clever way to do it, too!
Thanks
-- Syltrem http://pages.infinit.net/syltrem (OpenVMS related web site - en français) To reply to myself directly, remove .spammenot from my address "justme" <someq_at_rogers.com> a écrit dans le message de news: Vx9N8.245295$ah_.191253_at_news01.bloor.is.net.cable.rogers.com...Received on Tue Jun 11 2002 - 08:05:22 CDT
> here is your function
>
> create or replace function F_SPACES( in_string varchar2)
> return varchar2
> is
> lcl varchar2(2000);
> double_space varchar2(2) := ' ';
> single_space varchar2(1) := ' ';
> BEGIN
> lcl :=replace(in_string,double_space,single_space);
>
> if instr(lcl,double_space) > 0 then
> lcl := f_spaces(lcl);
> end if;
>
> return(lcl);
> END;
> /
> "Syltrem" <syltremspammenot_at_videotron.com> wrote in message
> news:1W2N8.3017$H67.15842_at_tor-nn1.netcom.ca...
> > Good morning everyone!
> >
> > I've been researching for :
> > a) a function that converts multiple spaces or tabs to a single space in
a
> > string
> > b) a way to suppress blank lines from the output of a SELECT in SQL*Plus
> >
> > For b) here's an example
> > set linesize 80
> > column a format a80
> > column b format a80
> > select 'xxx' a, ' ' b from dual;
> >
> > Since b is empty, a blank line is displayed. I would like to know if
> there's
> > any way to avoid printing blank lines. The thing is (in real life) b is
> > almost always empty so the reports looks like double-spaced.
> >
> > Merci beaucoup!
> >
> > --
> >
> > Syltrem
> > http://pages.infinit.net/syltrem (OpenVMS related web site - en
français)
> > To reply to myself directly, remove .spammenot from my address
> >
> >
> >
>
>