WIthout knowing anything about your research domain, take a look at what your sql looks like:
"select * from r where V1 like markerinfo$flank1[1] " You are asking to match literally "markerinfo$flank1[1]" and not the R object referred to. Try something more like, paste("select * from r where V1 like", markerinfo$flank1[1]) Sarah On Sun, Jun 28, 2020 at 4:35 PM Yuan Chun Ding <ycd...@coh.org> wrote: > > Hi R Users, > > I tried to use sql in R; test1 works well, > library(sqldf) > test1 <- sqldf("select * from r where V1 like > '%GCCATGTCAGCACACTACC%TGAAACCTTTAACTATTT%'") > test2 <- sqldf("select * from r where V1 like markerinfo$flank1[1] ") > > but I want to store the search content in a markerinfo file as shown below > > markerinfo$flank1[1] > [1] "%GCCATGTCAGCACACTACC%TGAAACCTTTAACTATTT%" > > However, test2 does not work well. > How to make test2 work? > Thank you, > > Ding > > > ---------------------------------------------------------------------- -- Sarah Goslee (she/her) http://www.numberwright.com ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.