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" -- View this message in context: http://r.789695.n4.nabble.com/Expected-behavior-of-as-character-tp3297558p3297558.html Sent from the R help mailing list archive at Nabble.com.
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]])
On 09/02/2011 11:11 AM, 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?Yes, you should look at what as.vector(resultset[1]) gives you. I think it is not what you expected. (Use str() to see that it is still a data frame). Duncan Murdoch> > as.character(c(-1,1,2,3,4,5,6,7,8,9)) > [1] "-1" "1" "2" "3" "4" "5" "6" "7" "8" "9"