Re: Spool & Trailing Blanks
Date: Fri, 29 Jan 93 15:03:30 GMT
Message-ID: <1993Jan29.150330.8939_at_netnews.whoi.edu>
In article <1993Jan25.133239.1_at_ntc02.tele.nokia.fi> kuismin_at_ntc02.tele.nokia.fi writes:
> This is what I get now:
>
> line1 line1 <LF>
> line2 line2 line2 line2 <LF>
> line3 line3 line3 <LF>
>
> This is what I want to have:
>
> line1 line1<CR><LF>
> line2 line2 line2 line2<CR><LF>
> line3 line3 line3<CR><LF>
How about
to_char(nvl(line1,'line1-null-value'),'line1-format-element')|| rtrim(to_char(nvl(line1,'line1-null-value'),'line1-format-element'),' ')
assuming line1, line2 and line3 are not char and you're not
trimming significant
blanks, line1-null-value is the replacement if line1 is null and
line1-format-element is the format for the to_char function
Continue with...
to_char(nvl(line2,'line2-null-value'),'line2-format-element')|| to_char(nvl(line2,'line1-null-value'),'line2-format-element')|| rtrim(to_char(nvl(line2,'line2-null-value'),'line2-format-element'),' ')
continue for line3 ? Received on Fri Jan 29 1993 - 16:03:30 CET