[R] Q about RSQLite

[bogdan romocea]

Check the way you imported the data / the SQLite documentation. The
\r\n that you see (you're on Windows, right?) is used to indicate the
end of the data lines in the source file - \r is a carriage return,
and \n is a new line character.


> -----Original Message-----
> From: r-help-bounces at stat.math.ethz.ch
> [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Wensui Liu
> Sent: Saturday, December 31, 2005 1:09 AM
> To: r-help at stat.math.ethz.ch
> Subject: [R] Q about RSQLite
>
>
> Happy new year, dear listers,
>
> I have a question about Rsqlite.
>
> when I fetch the data out of sqlite database, there is
> something like '\r\n'
> at the end of last column. Here is the example:
>    Sepal_Length Sepal_Width Petal_Length Petal_Width    Species
> 1           5.1         3.5          1.4         0.2 setosa\r\n
> 2           4.9         3.0          1.4         0.2 setosa\r\n
> 3           4.7         3.2          1.3         0.2 setosa\r\n
> 4           4.6         3.1          1.5         0.2 setosa\r\n
> 5           5.0         3.6          1.4         0.2 setosa\r\n
> 6           5.4         3.9          1.7         0.4 setosa\r\n
> 7           4.6         3.4          1.4         0.3 setosa\r\n
> 8           5.0         3.4          1.5         0.2 setosa\r\n
> 9           4.4         2.9          1.4         0.2 setosa\r\n
> 10          4.9         3.1          1.5         0.1 setosa\r\n
>
> Any idea?
>
> Thank you so much
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
>