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. ______________________________________________ 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.
