Can one search for a quote character inside text fields

[Jim Henry]

You guess was correct. I was doing a simple Find/Select.
I was able to make it work. It does defy my logic. It appears for  
every " I search for I must enter "". To find """, I enter """""". It  
works.

Thank you.

Jim


On Mar 23, 2008, at 9:30 PM, 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 ""
>
> or if you are searching for
>
> SomeField CONTAINS Some text with "quotes"
>
> then change it to
>
> SomeField CONTAINS Some text with ""quotes""
>
> If my guess is wrong, and this is actually a statement in a  
> procedure, then you just need to use a different quoting character  
> to quote the text. Something like
>
> Select SomeField contains {"}
>
> or
>
> Select SomeField contains {Some text with "quotes"}
>
> Dave
>
> ---- Original message ----
>> Date: Sun, 23 Mar 2008 16:30:25 -0500
>> From: Jim Henry <max4mac at mac.com>
>> Subject: Can one search for a quote character inside text fields
>> To: "Panorama Questions  Answers (Discussion)" <qna at provue.com>
>>
>>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna