Harold -
If there aren't any true quoted fields in the file, you
could pass the quote="" option to read.delim().
- Phil Spector
Statistical Computing Facility
Department of Statistics
UC Berkeley
spec...@stat.berkeley.edu
On Wed, 28 Jul 2010, Doran, Harold wrote:
I am reading in a very large file with names in it and R is truncating the
number of rows it reads in. The separator in this file is a pipe '|' and so I
use
dat <- read.delim('pathToMyFile', header= TRUE, sep='|')
It turns out that it is reading up to row 61145 and stopping and I think I see
why, but am not sure of the best solution to this problem. I see the name of
the person in the next row has a quote in it, such as:
Joe Sm"ith
I *think* this is causing a problem in the read in. In fact, whenever I use
? tail(dat)
? or dat[61145,]
R crashes.
But, it doesn't crash when I use head(dat) or index any other row. I could change my
raw data and manually delete this ". However, is there another solution within
the args of read.delim that would be useful as a solution such that I would not have
to manually change my raw data
Harold
[[alternative HTML version deleted]]
______________________________________________
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.
