Use an empty string instead of null..

SET V vtexttofix = (SRPL(.vtexttofix,.vlf,'',1))
SET V vtexttofix = (SRPL(.vexttofix,.vcr,.'',1))

and since it is a single character you can do:

SET V vtexttofix = (SRPL(.vtexttofix,.vlf,'',0))
SET V vtexttofix = (SRPL(.vexttofix,.vcr,.'',0))

And you should update your syntax to:

set var
instead of
set v

RStyle will appreciate it too...




----- Original Message ----- 
From: "Michael J. Sinclair" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, September 17, 2011 6:47 PM
Subject: [RBASE-L] - Getting rid of LF or CR in a variable


Hi All,

Is there a way to remove LF (linefeed) and CR (carriage return) from a 
variable?
I tried this...

SET V vlf = (CHAR(10))
SET V vcr = (CHAR(13))
SET V vnull = NULL

SET V vtexttofix = (SRPL(.vtexttofix,.vlf,vnull,1))
SET V vtexttofix = (SRPL(.vexttofix,.vcr,.vnull,1))

But when I try that, my vtexttofix ends up being a blank.

How do I do it?

Mike


Reply via email to