Message-ID: <434C04EE.9010702@pdf.com>
Date: 2005-10-11T18:31:10Z
From: Sundar Dorai-Raj
Subject: Reading # in file with read.csv
In-Reply-To: <OFBACE163D.50D4BAEF-ON88257097.006437C3-88257097.0064F8FC@bayer.com>
Michel Friesenhahn wrote:
> I'm using read.csv to read in a csv file containing '#' characters. For
> example, say I'm reading the following file (test.csv):
>
> var1,var2,var3
> a,b,c
> d,e#,f
> g,h,i
>
> It outputs:
>
>
>>read.csv("Raw Data\\test.csv")
>
> var1 var2 var3
> 1 a b c
> 2 d e
> 3 g h i
> Warning message:
> incomplete final line found by readTableHeader on 'Raw Data\test.csv'
>
> read.csv appears to be treating '#' as a comment even in input data. Is there a
> way to turn this interpretation off?
>
From ?read.csv:
comment.char: character: a character vector of length one containing a
single character or an empty string. Use '""' to turn off
the interpretation of comments altogether.
Thus, you should use:
read.csv("Raw Data\\test.csv", comment.char = "")
--sundar