[R] read tab delimited file from a certain line

[Christof Kluß]

Hello

thank you for the fast and helpful answer! Now the following works fine 
for me

x <- readLines(filename)
i <- grep("^year", x)
dlf <- read.table(textConnection(x[i:length(x)]),
        header = T, stringsAsFactors=F,sep="\t")

Greetings
Christof


Am 16-01-2013 16:55, schrieb Rui Barradas:
> 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.
>