Re: [R] How to read in this data format?

2007-03-05 Thread Bart Joosen
small datasets, it's ok for me. But I couldn't figure it out. Thanks Bart From: Gabor Grothendieck [EMAIL PROTECTED] To: Bart Joosen [EMAIL PROTECTED] CC: r-help@stat.math.ethz.ch Subject: Re: [R] How to read in this data format? Date: Thu, 1 Mar 2007 16:46:21 -0500 On 3/1/07, Bart Joosen

Re: [R] How to read in this data format?

2007-03-05 Thread jim holtman
] To: Bart Joosen [EMAIL PROTECTED] CC: r-help@stat.math.ethz.ch Subject: Re: [R] How to read in this data format? Date: Thu, 1 Mar 2007 16:46:21 -0500 On 3/1/07, Bart Joosen [EMAIL PROTECTED] wrote: Dear All, thanks for the replies, Jim Holtman has given a solution which fits my needs

[R] How to read in this data format?

2007-03-01 Thread Bart Joosen
Hi, I recieved an ascii file, containing following information: $$ Experiment Number: $$ Associated Data: FUNCTION 1 Scan1 Retention Time 0.017 399.8112184 399.87420 399.9372152 Scan2 Retention Time 0.021 399.8112181 399.8742

Re: [R] How to read in this data format?

2007-03-01 Thread Petr Klasterecky
Well, not extremely elegant, but should work: 1) open your file in some ascii text editor, delete the rubbish at the beginning up to line Scan 1, and replace all spaces in names - e.g. make a mass replace of 'Retention Time' by let say 'RetentionTime'. 2) Use read.table(), matrix() and

Re: [R] How to read in this data format?

2007-03-01 Thread Liaw, Andy
You can't expect general-purpose tools like read.table in R to be able to deal with highly specialized file format. Here's what I'd start. It doesn't put data in the format you specified exactly, but I doubt you'll need that. This might be sufficient for your purpose: dat -

Re: [R] How to read in this data format?

2007-03-01 Thread Gabor Grothendieck
Read in the data using readLines, extract out all desired lines (namely those containing only numbers, dots and spaces or those with the word Time) and remove Retention from all lines so that all remaining lines have two fields. Now that we have desired lines and all lines have two fields read

Re: [R] How to read in this data format?

2007-03-01 Thread jim holtman
153 Jim Holtman What is the problem you are trying to solve? - Original Message From: Gabor Grothendieck [EMAIL PROTECTED] To: Bart Joosen [EMAIL PROTECTED] Cc: r-help@stat.math.ethz.ch Sent: Thursday, March 1, 2007 12:35:43 PM Subject: Re: [R] How to read in this data format

Re: [R] How to read in this data format?

2007-03-01 Thread Bart Joosen
[EMAIL PROTECTED] Cc: r-help@stat.math.ethz.ch Sent: Thursday, March 01, 2007 6:35 PM Subject: Re: [R] How to read in this data format? Read in the data using readLines, extract out all desired lines (namely those containing only numbers, dots and spaces or those with the word Time

Re: [R] How to read in this data format?

2007-03-01 Thread Gabor Grothendieck
Sent: Thursday, March 01, 2007 6:35 PM Subject: Re: [R] How to read in this data format? Read in the data using readLines, extract out all desired lines (namely those containing only numbers, dots and spaces or those with the word Time) and remove Retention from all lines so that all

Re: [R] How to read in this data format?

2007-03-01 Thread Bart Joosen
Gabor, thanks for the clarification, now I understand the expression. Thanks to everyone Bart From: Gabor Grothendieck [EMAIL PROTECTED] To: Bart Joosen [EMAIL PROTECTED] CC: r-help@stat.math.ethz.ch Subject: Re: [R] How to read in this data format? Date: Thu, 1 Mar 2007 16:46:21 -0500 On 3