you have to double the backslash (\) in the serach
how to do it depends on how you perform the search.
f.i. you can define a variable in which you change the backslash with two backslashs and use the variable to perform the search
Just escape both backslash characters. So, to find "Acme\Inc", set $companyName = "Acme
220 Gaines Oak Way
Suwanee, GA 30024
Voice: (678) 313-5604
FileMaker Certified Developer
I thought about using the Substitute function when populating the variable to escape-out the backslash character but without success.
Substitute ( Company ; "\" ; " " )
...doesn't work. How would you do it?
Substitute ( Company ; "\\" ; "\\\\" )
Substitute ( Company ; Char ( 92 ) ; Char ( 9200092 ) )
Nope, that didn't work. I had hoped to replace the backslash with a space. I would even have been satisfied with simply removing the backslash character. Instead, with your suggestion, "Boasberg\Wheeler Comm. Inc." became "Boasberg\\Wheeler Comm., Inc."
"Boasberg\Wheeler Comm. Inc." became "Boasberg\\Wheeler Comm., Inc."
And that's exactly what you need for an "exact match" find, using the == operator:
Enter Find Mode 
Set Field [ Companies::Name ; "==" & Substitute ( $companyName ; Char ( 92 ) ; Char ( 9200092 ) ) ]
Perform Find 
This soukd be the find and it works in my system
Set Variable[$CompanyName; Value:Substitute(Table::Name;"\\";"\\\\")]
Enter Find Mode[Specified Find Requests:Find Records; Criteria:Table::Name: “=$CompanyName”]
Perform Find[ ]
Yes, that does seem to work. Why does it work?
Why does it work?
Because the backslash character has a special meaning when used in find criteria: "escape next character". When you have a pair of backslashes, the first one escapes the second one.
It's the same as when finding e-mail addresses: to find email@example.com, you must search for ==someone\@somewhere.com because @ too has a special meaning when used in find criteria.
I used an script that was simply this:
Perform find/replace [char(92);"";Replace All]
It removed over 700 "\" from a data base I had imported from a word file.