Thanks both. I have been _trying_ to make it a rule not to change any of the SET characters if there is an alternative. Not because it's a problem as such but because when testing if something bombs out I get caught so often.
If I had to place a bet on who it was that had an escape sequence it would have been you Dennis, or Bill Downall - perhaps it was for something else. Emmit, I'll try your suggestion & report back. Regards, Alastair. ----- Original Message ----- From: Dennis McGrath To: RBASE-L Mailing List Sent: Thursday, January 31, 2008 2:37 PM Subject: [RBASE-L] - RE: Finding '__' query In this case you will need to temporaily change the SINGLE character. SET SINGLE=? Notice no spaces around the = Now search for your underscores. When done SET SINGLE=_ Dennis McGrath Not enough coffee yet this morning. Make that (CHAR(95)+CHAR(95)). Emmitt Dove ------------------------------------------------------------------------------ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove Sent: Thursday, January 31, 2008 7:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Finding '__' query Alastair, Try setting a variable to (CHAR(45)+CHAR(45)) and looking for the variable. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Thursday, January 31, 2008 6:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Finding '__' query I am trying to find and then eliminate a realstring of two underscores in a file name. Because the underscore is the single wildcard, probably not surprisingly, I am finding far more than I want. I seem to remember that there was a way of escaping the character to force the search to find the underscores rather than any character. Can anybody remind me of how to do it, please? Thanks & regards, Alastair. ---------------------------- Alastair Burr St. Albans, UK. [EMAIL PROTECTED] ----------------------------- ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.17/1252 - Release Date: 30/01/2008 20:51
