[R] Reading column names with spaces using dbGetQuery
Raji
raji.sankaran at gmail.com
Wed Sep 28 02:18:43 CEST 2011
I have been trying to read a dataset which has spaces in column names using
dbGetQuery from RJDBC.
* dataFrame<-dbGetQuery(conn,"select 'Sepal Length','Sepal Width' from
"326_1_Result")*
The resulting dataframe contains column names as
"*Sepal.Length" "Sepal.Width" *
But i would like to maintain the spaces in column names as it is.Is there
any method is R similar to check.names=FALSE , which can be used in
dbGetQuery for maintaining the spaces in column names.
Thanks for your help.
--
View this message in context: http://r.789695.n4.nabble.com/Reading-column-names-with-spaces-using-dbGetQuery-tp3849597p3849597.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list