Damn! Ed was correct! I knew I should have tested CHRTRAN() first!!! But, STRTRAN() only needs the replacement value if it is non-blank.
Gil Damn! > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of mrgmhale > Sent: Friday, February 02, 2007 5:12 PM > To: [EMAIL PROTECTED] > Subject: RE: remove cr lf from memos > > > > ChrTran(MyString, Chr(13)+chr(10)+chr(141), "") > > I thought the trailing [,"")] was optional if you wanted to replace the > String Searched For with <BLANK>. Then again, I usually use STRTRAN(). I > guess I ought to have looked before shooting off like that, eh? Oooops, > too late, the eMail went out on its own. Darned Outlook! > > Gil > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Ed Leafe > > Sent: Friday, February 02, 2007 3:21 PM > > To: [EMAIL PROTECTED] > > Subject: Re: remove cr lf from memos > > > > > > On Feb 2, 2007, at 2:20 PM, Vince Teachout wrote: > > > > > ChrTran(MyString,Chr(13)+chr(10)+chr(141)) anytime, correct? Not bad. > > > > Close: you need the replacement argument: > > > > ChrTran(MyString, Chr(13)+chr(10)+chr(141), "") > > > > -- Ed Leafe > > -- http://leafe.com > > -- http://dabodev.com > > > > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
