No.. I copy pasted his stuff and didn't check that.. :-( ----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Sunday, September 18, 2011 7: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 : > : > : > :
