[R] read.table understands comment field and ignores text

Jack T. jackt at fpc.org
Thu Apr 22 21:05:10 CEST 2010


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?




-- 
View this message in context: http://r.789695.n4.nabble.com/read-table-understands-comment-field-and-ignores-text-tp2021036p2021036.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list