[R] create string of comma-separated content of vector
mark at wardle.org
Tue May 19 20:03:12 CEST 2009
x <- seq(0,10,1)
paste(x, collapse=", ")
2009/5/19 Katharina May <may.katharina at googlemail.com>:
> how do I create a string of the comma-separated content of a vector?
> I've got the vector i with several numeric values as content:
> num 99
> and want to create a SQL statement to look like the following where
> the part '(2, 4, 6, 7)' should be
> the content of the vector i:
> select * from [biomass_data$] where site_no in (2, 4, 6, 7)
> Here my approach (which doesn't work):
> site_all_data <= sqlQuery(channel, "select * from [biomass_data$]
> where site_no in (",paste(i,sep=","),") )
> sorry for spaming so much today to the mailing list...
> Time flies like an arrow, fruit flies like bananas.
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
Dr. Mark Wardle
Specialist registrar, Neurology
More information about the R-help