[R] Parsing txt file

[karthicklakshman]

Hello,

I have a tab limited text document with multiple lines as mentioned below,



#FILE FORMAT
#Book	bookname	author	publisher	pages
#CD	name	content
####################################################################################################
----------------------------------------------------------------------
Book	bioR	xxx	abc publishers	230
CD	biorexamples	chapter5
----------------------------------------------------------------------
Book	bioc++	mmm	tata publishers	400
CD	samples	workexamples
CD	data	experiments
----------------------------------------------------------------------
Book	management tools	aaa	some publishers	200
----------------------------------------------------------------------


here the texts "book" and "CD" are present in each block.

now, I am interested in creating a data frame with two columns, column
names="bookname" and "content". Using "grep" it is possible to pick specific
rows (grep("^book, finename")) but my expertise in programming is limited to
create the mentioned data.frame.

Note: the rowname "book" is present in all blocks but "CD" is variable (ie.,
some block has two and some with no CD row, as shown above)

please help me in creating something like this,


     bookname   content
[1] bioR           chapter5
[2] bioc++        workexamples, experiments
[3] management tools   NA


Thanks in advance,
karthick
 
-- 
View this message in context: http://r.789695.n4.nabble.com/Parsing-txt-file-tp3035749p3035749.html
Sent from the R help mailing list archive at Nabble.com.