On Fri, Feb 5, 2010 at 10:23 AM, analys...@hotmail.com
<analys...@hotmail.com> wrote:
> the csv files are downloaded from a database and it looks like some
> character fields contain the CR-LF sequence within them.
>
> This causes R to see a new record/row and the number of rows it sees
> is different (usually higher) from the number of rows actually
> extracted.
Hard to tell without an example, but I just tried this in a file:
1,2,"this
is a test",99
2,3,"oneliner",45
and:
> read.table("test.csv",sep=",")
V1 V2 V3 V4
1 1 2 this\nis a test 99
2 2 3 oneliner 45
seemed to work. But if your strings aren't "quoted" (hard to tell
without an example) then you might have to find another way. Hard to
tell without an example.
Barry
______________________________________________
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.
