Hi Mike, First, if you want to change blanks to a hard blank your SRPL function is backwards. It should be:
SRPL(columnname,' ',.vHARDBLANK,0) Secondly, CHAR(255) is a hard blank in the ASCII character set. In the ANSI character set it is ΓΏ (y with umlaut). Y with umlaut is equivalent to y in a SRPL, so that explains why your y's are being replaced! Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair Sent: Friday, November 30, 2012 12:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Code that quit working Hi All, I have an app that was working just fine until recently, and now I can't figure out why it is acting differntly. I am running this code in Rbase for DOS... Here is the code... SET VAR vHARDBLANK = (CHAR(255)) UPDATE tablename SET columnname = (SRPL(columnname,.vHARDBLANK,' ',0)) The goal is to clean up the appearance of a report by changing any blanks to a hard blank. The code was working fine until yesterday, and now the above code erases the letter 'Y' Why is the letter 'Y' being treated like a blank? Thanks Mike Sinclair --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
