Hey Mark, What about something like
read.csv(file="yourfile", skip=1, header=TRUE) Hope that helps, Joshua On Sun, Jun 28, 2009 at 2:05 PM, Mark Knecht<markkne...@gmail.com> wrote: > Hi, > Complete newbie to R here. Just getting started reading manuals and > playing with data. > > I've managed to successfully get my *.csv files into R, however I > have to use header=FALSE because the real header starts in line #2. > The file format looks like: > > PORTFOLIO EQUITY TABLE > > TRADE,MARK-SYS,DATE/TIME,PL/SIZE,PS METHOD,POS SIZE,POS > PL,DRAWDOWN,DRAWDOWN(%),EQUITY > > 1,1,1/8/2004 12:57:00 PM,124.00,As Given,1,124.00,0.00,0,"10,124.00" > 2,1,1/14/2004 9:03:00 AM,-86.00,As Given,1,-86.00,86.00,0.849,"10,038.00" > 3,1,1/14/2004 11:51:00 AM,-226.00,As Given,1,-226.00,312.00,3.082,"9,812.00" > 4,1,1/15/2004 12:57:00 PM,134.00,As Given,1,134.00,178.00,1.758,"9,946.00" > > where the words "PORTFOLIO EQUITY TABLE" make up line 1, the rest of > the text is on line 2, and then the lines starting with numbers are > the real data. (Spaces added by me for email clarity only.) > > If I remove the first line by hand then I can use header=TRUE and > things work correctly, but it's not practical for me to remove the > first line by hand on all these files every day. > > I'd like to understand how I can do the read.csv but skip the first > line. Possibly read the file, delete the first line and then send it > to read.csv, or some other way? > > Thanks in advance, > Mark > > ______________________________________________ > 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. > -- Joshua Wiley Junior in Psychology University of California, Riverside http://www.joshuawiley.com/ ______________________________________________ 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.
