[R] read tab delimited file from a certain line
Rui Barradas
ruipbarradas at sapo.pt
Wed Jan 16 16:55:21 CET 2013
Hello,
Read the file using readLines, then grep "^year". You can then use a
textConnection to read.table:
x <- readLines(con = textConnection(
"informations (unknown count of lines)
... and at some point the table
------
year month mday value
2013 1 16 0 "))
# This is it
i <- grep("^year", x)
read.table(textConnection(x[i:length(x)]), header = TRUE)
Hope this helps,
Rui Barradas
Em 16-01-2013 14:17, Christof Kluß escreveu:
> Hi
>
> I would like to read table data from a text-files with extra
> informations in the header (of unknown line count). Example:
>
> informations (unknown count of lines)
> ... and at some point the table
> ------
> year month mday value
> 2013 1 16 0
> ...
>
> If it was an excel file I could use something like read.xls(...,
> pattern="year") But it is a simple tab seperated text-file. Is there
> an easy way to read only the table? (Without dirty things ;))
>
> Thx
> Christof
>
> ______________________________________________
> R-help at 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.
More information about the R-help
mailing list