OK, here is the next in my beloved series "Stuff that is now stupid in
FM8 that wasn't stupid in FM6"

I have some data that might be any of:

1 3/4" Panel
1" Panel
1/4" Panel

If my users try to do a find with any of that text, zero records are
found.

if I search for : 1 3/4
then it will return those records (which is fine)

if I search for : Panel
it will return all of the records with that word (which is fine)

But what about the quote character is fouling things up? It goes
without saying...it all worked fine in FM6.

Thanks anyone!

"Paul Bruneau" <paul (AT) ethicalpaul (DOT) com> schreef in bericht
news:1182256031.738052.91080 (AT) n60g2000hse (DOT) googlegroups.com...
Yes. There are some changes. The " now is to be expected as the starting of
a string. When using a single " it has to be escaped, likewise as in a unix
setting. The escape character is the \

for finding the complete text the user has to enter
1 3/4\" Panel

The same goed for calcs. When using a quote in previous version you could
either use a global field holding the ". Or use """" to represent a quote.
With the new versions you must use \"
So if a calculation exactly has to read:
John says: "Hallo world".
you have to enter the following in the calc
"John says: \"Hallo World\"."

Takes some getting used to....

Keep well, Ursus

Thanks Ursus-

I had seen the new escape notation for calcs but I had no idea it
would be required in Finds. I'm sure I can get used to it, but my
users? That's another story.

thanks again!

On Jun 19, 9:28 am, Paul Bruneau <p... (AT) ethicalpaul (DOT) com> wrote:
I find the best solution to this is to use 'shadow fields' with
problems like that stripped out. And then script finds against the
shadow fields. Or alternatively script the find to 'cook' the data to
escape the " marks. This limits your ability to both use AND find
quote marks, but it generally gives the users the functionality they
need, as they aren't likely to do any advanced character escaping
anyway.

-cheers,
dave