Re: Re: Vista search including double quote

On Thu, 5 Mar 2009 13:18:01 -0800, Vern Rabe
<VernRabe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thanks. That sounds like it may be close enough, but when I try it, I get
even more confusing results. I have a file with the string -
ProtectionLevel">2< - in it. When I search for the string - Protection - it
finds it. When I search for the string - "Protection - (including the leading
double quote) it finds it. When I search for the string - "Protection" - it
doesn't find it. There is only one occurance of the word Protection in the
document.

Vern,
There is no need or reason to enclose one word within quotes in a content
search. Your first query above was the correct one because in content
searches, the upper case L following Protection is considered to begin a
separate word. In other words, look for the simplest query syntax that
works. The only reason that I put quotes around my previous example was
that your string - ProtectionLevel">1< - is interpreted by search as a
phrase, not as a single word.

More that I don't understand:

When I search for - "P - several documents are identified
When I search for "Pr" - two documents are identified
When I search for "P" - one document is identified

That doesn't make sense

All three of those queries are incorrect, hence the inconsistent results.
As I said, search is now word-based (like Google) and not character-based.
Avoid punctuation characters and never add quotes to a content search
except to enclose a phrase. If you want to search content for a word that
begins with Pr, either type the whole word or type Pr* to find all words
that begin with those two letters.

Doug M. in NJ

"Retroman" wrote:

On Thu, 5 Mar 2009 08:05:04 -0800, Vern Rabe
<VernRabe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Vista ultimate. I want to search multiple dtsx files for the existence of a
string that includes a double quote. Specifically:

ProtectionLevel">1<

When I search for that string, it appears to treat the double quote as a
space, and returns files that contain both "ProtectionLevel" and ">1<", but
not necessarily juxtaposed. Maybe there's an escape character I can prefix
the double quote with?

Thanks
Vern Rabe

Hello Verne,

If there is, I have never seen a reference to it in the MS documentation
for search. Search is now word-based and it sees punctuation as a break
between words. The closest thing that I can suggest is to use a wild card
character and to enclose the whole string in quotes, like this:

"ProtectionLevel?>1<"

I just tried a similar search on some HTML files, and this query returned
only files with content containing the full string when a quote character
occupied the wild card position:

"ball?><A"

Of course, it will also return the string with other characters in the
wild card position. I don't have a solution for that, maybe someone else
here does.

Doug M. in NJ

.

Relevant Pages

  • Re: Beginners Program
    ... I'd put single quotes aroung the, ... If you are putting "s in a string then it is usually best to use a different ... input file things could go wrong. ... and that the final line of input does end with a newline character. ...
    (comp.lang.perl.misc)
  • Re: Can an "Update" Query insert quotation marks around text?
    ... quotes) is because the software is reacting to the presence of your quotes. ... that text string is delimited by " characters within the software, ... software doubles the " character because that tells the software that the " ... and the last " character marks the end of the text string. ...
    (microsoft.public.access.queries)
  • Re: Update existing values incrementally w/UPDATE SQL
    ... I think it would be safe to say, use the Dim statement any time you are ... Dim basically tells vba that you want to initiate a new variable. ... As far as quotes go, this was one of the trickiest ... Consider vba's interpretation of a string: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Update existing values incrementally w/UPDATE SQL
    ... and in the book; Access 2007 VBA Programmer's Reference. ... As far as quotes go, this was one of the trickiest ... Consider vba's interpretation of a string: ... when an SQL is processed (I use an SQL example because it is the most ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL Injection with JDBC
    ... You could try wrapping your test in a PL/SQL block, ... Replace quotes in the user strings with a harmless character, ... public static String requote(String str) ...
    (comp.lang.java.programmer)
Loading