[R] SQLite: When reading a table, a "\r" is padded onto the last column. Why?
Søren Højsgaard
Soren.Hojsgaard at agrsci.dk
Wed Jan 3 02:23:29 CET 2007
Hi,
I put the iris data into a SQLite database with
dbWriteTable(con, "iris", iris, row.names=F, overwrite = T)
Then I retrieve data from the database with
rs <- dbSendQuery(con, "select * from iris")
d1 <- fetch(rs)
dbClearResult(rs)
Then I get
> head(d1)
Sepal_Length Sepal_Width Petal_Length Petal_Width Species
1 5.1 3.5 1.4 0.2 setosa\r
2 4.9 3.0 1.4 0.2 setosa\r
3 4.7 3.2 1.3 0.2 setosa\r
4 4.6 3.1 1.5 0.2 setosa\r
5 5.0 3.6 1.4 0.2 setosa\r
6 5.4 3.9 1.7 0.4 setosa\r
Can anyone explain the extra "\r" at the end? I am on Windows XP using R 2.4.1
Thanks in advance
Søren
More information about the R-help
mailing list