koooee wrote:
is this the expected behavior of as.character ?
resultset is a data.frame from a sqlQuery() using RODBC
a = as.character(as.vector(resultset[1]))
a
[1] "c(-1, 1, 2, 3, 4, 5, 6, 7, 8, 9)"
I would expect the statement above to return similar to the result below, am
I missing something?
as.character(c(-1,1,2,3,4,5,6,7,8,9))
[1] "-1" "1" "2" "3" "4" "5" "6" "7" "8" "9"
What class is resultset[1] ? A list, yes? Thus the behavior.
try
> as.character(resultset[[1]])
______________________________________________
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.