R help - Nov 2011 - Reading a file w/ two delimiters

Hi all,

I've been scratching and poking, but basically, the file I need to read has
two delimiters that I need to contend with. The first is that the file
contains
tabs (\t) , instead of newlines (\n), and the second is that the fields
have 
| for the seperators. I can easily do a read if I first convert the \t to
\n
and then use read.table to get the file read with the | separator. But,
what I would really like to do, is do this all within R. I have a lot of
files
to read and do analysis on.

I can read the data into a table using the \t has delimiter, but can't
figure
out how to take that table data and use the | for separation, I've look at
string splits, etc. but haven't figured out how to split the whole table.

Any thoughts ? hints ?

Thanks,

Jim


The contents of this e-mail are intended for the named a...{{dropped:6}}

Hi Jim,

You can read the text file using readLines. This puts each line in the
file into an element of a list. Then you can go through the lines
manually (e.g. using grep, sub, strsplit) and create your data.frame.

cheers,
Paul

On 11/18/2011 12:37 PM, Langston, Jim wrote:
> Hi all,
>
> I've been scratching and poking, but basically, the file I need to read
has
> two delimiters that I need to contend with. The first is that the file
> contains
> tabs (\t) , instead of newlines (\n), and the second is that the fields
> have 
> | for the seperators. I can easily do a read if I first convert the \t to
> \n
> and then use read.table to get the file read with the | separator. But,
> what I would really like to do, is do this all within R. I have a lot of
> files
> to read and do analysis on.
>
> I can read the data into a table using the \t has delimiter, but can't
> figure
> out how to take that table data and use the | for separation, I've look
at
> string splits, etc. but haven't figured out how to split the whole
table.
>
> Any thoughts ? hints ?
>
> Thanks,
>
> Jim
>
>
> The contents of this e-mail are intended for the named a...{{dropped:6}}
>
> ______________________________________________
> 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.

-- 
Paul Hiemstra, Ph.D.
Global Climate Division
Royal Netherlands Meteorological Institute (KNMI)
Wilhelminalaan 10 | 3732 GK | De Bilt | Kamer B 3.39
P.O. Box 201 | 3730 AE | De Bilt
tel: +31 30 2206 494

http://intamap.geo.uu.nl/~paul
http://nl.linkedin.com/pub/paul-hiemstra/20/30b/770