[R] Separator with " | " for read.table

Gundala Viswanath gundalav at gmail.com
Mon Jun 16 03:11:53 CEST 2008


Hi,

I have the following data file to be parsed and captured as a data frame:

__DATA__
#GDS_ID GENE_NAME GENE_DESCRIPTION GENE_FUNCTION
1007_s_at | DDR1 | discoidin domain receptor tyrosine kinase 1 | protein-coding
1053_at | RFC2 | replication factor C (activator 1) 2, 40kDa | protein-coding
117_at | HSPA6 | heat shock 70kDa protein 6 (HSP70B') | protein-coding

__END__

In particular it is separated by " | " , namely - space, bar, space.
However I tried this without avail:

geneinfo <- read.table("mydata.txt", sep=" | ", comment.char="\#")
print(geneinfo)

I also tried with sep= "|", it gave a wrong parsing. Please advice.

- Gundala Viswanath
Jakarta - Indonesia



More information about the R-help mailing list