and all i want to do is to importing this report into R, but the problem is that the report has multiple headers as you see! so i can't use read.table() that only supports single header files
i've to mention that the headers are informative ( the first number in the headers are informative ) and i dont want to read the whole file as a string and write a parser for parsing and extracting data.
some of the tables are empty ( like the 1 Reverse here ) but maybe we have a "Reverse" table with records
I removed the header lines and input the remainder into a data.frame
df = read.table(text=lns[!idx])
Then added a column to the data frame telling me the header line that the row came from. To do this I had to figure out how many times the header line needed to be replicated
I'm not sure what a massive file looks like, but the above is probably good enough for anything that'll be convenient to manipulate in some down-stream way. Hope that helps!
thanks a lot !