In 9.5, which uses the ANSI character set, CHAR(255) is a "y" with an umlaut. For the purposes of SRPL, "y" without umlaut is equivalent to "y" with an umlaut (ΓΏ). I am not sure whether the CASE setting affects SRPL.
In the ANSI character set, CHAR(160) is the hard blank. To type ASCII characters with a CHAR number greater than 127, hold down the [Alt] key while you use the number pad to type the 3-digit character number. To type the ANSI character, add a zero to the front of the number. For example, [Alt]-255 is a the (ASCII) hard blank whereas [Alt]-0255 is "y" with an umlaut. 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: Saturday, December 01, 2012 3:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Help with SRPL Hi All, My problem is solved, but my education is very incomplete. Perhaps somebody could explain the following... Many moons ago in RBase for DOS I needed to make some variables that were exactly 80 characters long. I added hard blanks (CHAR(255)) to pad the variable to create the length I needed. When I printed the report with the hard blanks, my printer placed a funny looking cursive small case f wherever there was a hard blank. To fix that, I used the SRPL string replacement function to replace the hard blanks with a ' '. All was well. Recently, when my new Rbase 9.5 32 database lost all of its forms (know idea why that happened) I rebuilt the database using the famous UNLOAD ALL command and put the forms back by copying them from the previous days backup (that was soooo cool and soooo easy). BUT now my SRPL function that was replacing hard blanks with a ' ' was also replacing the letter 'Y' with the ' '. For the purpose full disclosure, this new problem happens when I use RBase for DOS to do the SRPL on a table in a database that was created by Rbase 9.5 32. What magic setting within Rbase for DOS or Rbase 9.5 32 would cause the SRPL to replace the letter 'Y' with a blank with this code.... SET VAR vhardblank = (CHAR(255)) SET VAR vword = (SRPL(.vword,.vhardblank,' ',0)) FWIW, I solved the problem by padding the variables with a (CHAR(127)) instead of a (CHAR(255)) and now the code is behaving properly. (CHAR(127)) looks like a little house, ie a square with a pointed top. I don't really need to fix this problem any more, but I would like to understand why it happened. I guess I am just an Rbase nerd. TIA. Mike Sinclair
