http://ascii-table.com is a good place to see Ascii/Ansi
From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair Sent: Friday, November 30, 2012 11:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Code that quit working You are a genius! So how do I do this without touching the Y ? Can I do something in the rbase.cfg file? One more ancillary question...some of the texts I have a character that looks like a small case cursive f. How do I find out what ANSI/ASCII character it is so I can get rid of it? Mike ________________________________ From: Stephen Markson <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Fri, November 30, 2012 12:16:20 PM Subject: [RBASE-L] - RE: Code that quit working 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]> [mailto:[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
