Spool & Trailing Blanks

    My environment:

• SunOS Release 4.1.3
• Oracle SQL*Plus v.3.0.12.2.1
• Oracle RDBMS v.6.0.36.4.1
• Oracle PL/SQL v.1.0.35.1.1

        SQL*Plus uses LINESIZE setting and puts trailing blanks in the
        end of each line it spools.  I need to remove all these blanks!

        Can this be done by SQL*Plus?
        What unix commands could be used to do this?  I'm novice with unix.

        2) Unix to Dos convertion

        My final aim is to convert the spooled file, which in UNIX
        format, into DOS format.  That is, I need to put <CR><LF>
        instead of <LF> in the end of each line.

        Can this be done by SQL*Plus?
        What unix command could be used to do this? I'm novice with unix.

    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>

    Any help is appreciated!

    -Mikko Kuismin Received on Mon Jan 25 1993 - 12:32:39 CET