Re: running SQR (produces reports) on Unix box

[Scott Barnes <sbarnes@MAIL.WESLEYAN.EDU>]

Hello everyone,

I have some class notes I am reading with junk in them, carriage returns,
spaces, etc.
I want to print them with the wrap and strip the line feeds or carriage
return line feeds, and places were there are more than two spaces, and not
have ON default to line feed,  I tried <0> = null but that produced an
error.  I am on oracle eight and not sure which version of SQR I am new here.

thanks for any help

scotty


BEGIN-SELECT LOOPS = 1

CN.DESCRLONG  (,10)  WRAP 55 5   LINE-HEIGHT = 2 STRIP=<13><32><10> ON=<07>
        DISPLAY ' SELECTED NOTE'
FROM
PS_CLASS_NOTES CN
WHERE
&CT.STRM = CN.STRM AND
&CT.CRSE_ID = CN.CRSE_ID
END-SELECT