Mike,
It looks to me that you have to create a file with records of 80 characters. There is an easy way doing this in Rbase. In reports there is a feature menu 'File' option 'Print to text file setup' in which you are able to define the length of a record. If it is less than 80 characters it will be filled by spaces. My approach in these cases is to create a table with a text column of 80 characters, fill it with the rows and print them using this report. There are severable option to select these rows for printing. The simplest one is to empty the table before building up the new one or create an empty temp table using project, more complicated is to apply selection criteria to the table, so that you are able to keep the rows available for later use. In this case you are able to reprint the same file after a while. The print statement looks like this: PRINT <reportname> OPTION TXT |FILENAME <filename> |SHOW_CANCEL_DIALOG OFF |OPEN OFF Hope this helps Tony IJntema From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair Sent: zaterdag 1 december 2012 21:59 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
