R help - Nov 2010 - how to make R overlook string character

I am really new to R and would appreciate some help to sort out a problem
with data extraction from a large file.

I have entered the following command to filter data from a large data set
called "upanddown" such that those records in upanddown corresponding
to
blockType=3'UTR are transferred to a new file called "new":

new<-sqldf("select * from upanddown where blockType
IN('3'ext') ")

The problem is that when R encounters the ' symbol after 3 it gets confused.
What I would like to know is how I can make R overlook the ' symbol after 3
to make it recognise 3'UTR as one search string?

If instead I had new2<-sqldf("select * from upanddown where blockType
IN('exon') ") then it works like a charm since there are no
confusing
symbols in search string "exon".

Thanks in advance for all your help.

Regards
Max
QUT/ Australia


p.s I would be grateful for any suggestions for data filtering in R
-- 
View this message in context:
http://r.789695.n4.nabble.com/how-to-make-R-overlook-string-character-tp3056653p3056653.html
Sent from the R help mailing list archive at Nabble.com.

Try this:

new<-sqldf("select * from upanddown where blockType
IN("\3'ext\") ")



On Wed, Nov 24, 2010 at 2:24 AM, mariaseg <mariaseg@qut.edu.au> wrote:
>
> I am really new to R and would appreciate some help to sort out a problem
> with data extraction from a large file.
>
> I have entered the following command to filter data from a large data set
> called "upanddown" such that those records in upanddown
corresponding to
> blockType=3'UTR are transferred to a new file called "new":
>
> new<-sqldf("select * from upanddown where blockType
IN('3'ext') ")
>
> The problem is that when R encounters the ' symbol after 3 it gets
> confused.
> What I would like to know is how I can make R overlook the ' symbol
after 3
> to make it recognise 3'UTR as one search string?
>
> If instead I had new2<-sqldf("select * from upanddown where
blockType
> IN('exon') ") then it works like a charm since there are no
confusing
> symbols in search string "exon".
>
> Thanks in advance for all your help.
>
> Regards
> Max
> QUT/ Australia
>
>
> p.s I would be grateful for any suggestions for data filtering in R
> --
> View this message in context:
>
http://r.789695.n4.nabble.com/how-to-make-R-overlook-string-character-tp3056653p3056653.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>


-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

	[[alternative HTML version deleted]]