Searching a field for " (AREV Specific)
At 29 JUN 2001 09:01:17AM Mark Watford wrote:
Using AREV 1.16. Trying to do a search in a field to find any records where a single " is in the description. By using the \ search mode and typing in " in the field an error occurs which states that you have an unbalanced set of quotes. I have tried """ and it will search the field and select records but they do not contain ". Have tried LIST statements with the same result. Any suggestions.
At 29 JUN 2001 09:20AM Matt Sorrell wrote:
Mark,
I haven't used that version of Arev before, but can you surround the " with ', like this '"'?
I've used that before in 3.12.
msorrel@greyhound.com
At 29 JUN 2001 09:40AM Peter Kassinski wrote:
I can't realize this query inside template too.
Maybe another methods are convinient for you ?
1.TCL command
list table ( with field1 containing '"' ) field1
2.
Strings in Rbasic program:
sss= " select table ( with field1 containing ":"'":'"':"'":" ) " perform sss
and you can manipulate with records contains ".
Best regards
Peter