Can one search for a quote character inside text fields

Robert Ameeti Robert at Ameeti.net
Mon Mar 24 06:54:25 PDT 2008


At 9:30 PM -0500, 3/23/08, David Thompson wrote:

>Yes, you can. Reading between the lines, so to speak, I suspect your 
>question is really, "can you use the Find/Select... dialog to search 
>for a quote character inside text fields?" That is where it can be a 
>bit tricky, because Panorama automatically wraps quotes around 
>whatever text you type into that dialog, and using quotes to quote 
>text that contains quotes can lead to a syntax error if you don't do 
>it right. The trick is to replace each quote within the text with 2 
>quotes. So if you have been searching for
>
>SomeField CONTAINS "
>
>then change it to
>
>SomeField CONTAINS ""

Thanks David. I was waiting for your response and as usual, you've 
pulled an answer for which I had been unable to do myself.

I found it interesting that I was able to search for a single quote 
by simply entering that single quote in the Search criteria field. 
But searching for a double quote was not working similarly. Why would 
the rule be different for a double quote than a single quote?

I did try to search for a double quote but that provided an 
unbalanced search criteria error. If Panorama simply does wrap 
whatever is entered into that Search field with a set of double 
quotes, why then is Panorama not searching for exactly what I 
entered?, a grouping of double quotes together with no space between 
them? After Panorama peels off the balanced quotes, there should be 
nothing left to search for. My original best guess was to search for 
'"' (single quote, double quote, single quote) but that too did not 
work although it seemed like it should.
-- 

<><><><><><><><><><><><><><><><><><>
Robert Ameeti

A PBS mind in an MTV world.
<><><><><><><><><><><><><><><><><><>


More information about the Qna mailing list