On Apr 22, 2010, at 3:05 PM, Jack T. wrote:
Hi I'm trying to import a large csv file without quotes around each
field.
This creates some problems when there are "#" characters in certain
strings
as R understands its comment field and ignores the rest of the line.
Here's an example:
var1, var2, var3, var4
one, two, three, four
Use this in R to get off clipboard:
read.table("clipboard", header=F, sep=",",na.strings=c("NULL", ""),
dec=".", strip.white=TRUE, fill=T)
Now try it with this table:
var1, var2, var3, var4
one#, two, three, four
Notice R ignores everything after the # character. Is this
something that
can be fixed?
?read.table
Read the documentation with particular attention to comment.char
--
David Winsemius, MD
West Hartford, CT
______________________________________________
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.