Mike, Try the following syntax using the keyword NULL instead of assigning NULL to a variable.
SET V vtexttofix = (SRPL(.vtexttofix,.vlf,NULL,1)) SET V vtexttofix = (SRPL(.vexttofix,.vcr,NULL,1)) Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 >________________________________ >From: Dennis McGrath <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Sunday, September 18, 2011 6:46 AM >Subject: [RBASE-L] - Re: Getting rid of LF or CR in a variable > > >did you notice your first expression is missing the dot on vnull?? > > >SET V vtexttofix = (SRPL(.vtexttofix,.vlf,vnull, >1)) > >SET V vtexttofix = (SRPL(.vexttofix,.vcr,.vnull,1)) > >Dennis McGrath >[email protected] >[email protected] > > > >On Sat, Sep 17, 2011 at 9:18 PM, Mike Byerley <[email protected]> wrote: > >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 >> >> >> > > >
