Message-ID: <f8e6ff0504112509333c2d5df3@mail.gmail.com>
Date: 2004-11-25T17:33:21Z
From: Hadley Wickham
Subject: Searching for a string in RSQLite
In-Reply-To: <f8e6ff0504112509126eeb3aa4@mail.gmail.com>
> You may find dQuote() and sQuote() to be helpful, but a better
Ooops, dQuote() and sQuote() won't be of much use as they escape
quotes with quotes.
A regular expression should do the trick: gsub("'", "\\\\'", "Hi
y'all"). (Note that this looks like it has too many backslashes, but
this is just the way R prints escaped strings, use str() to see the
unescaped string)
Hadley