[R] select portion of text file using R

Luigi Marongiu marongiu.luigi at gmail.com
Mon Apr 20 09:28:01 CEST 2015


Dear all,
I have a flat file (tab delimited) derived from an excel file which is
subdivided in different parts: a first part is reporting metadata,
then there is a first spreadsheet indicated by [ ], then the actual
data and the second spreadsheet with the same format [ ] and then the
data.
How can I import such file using for instance read.table()?
Many thanks
regards
Luigi

Here is a sample of the file:
* Experiment Barcode =
* Experiment Comments =
* Experiment File Name = F:\array 59
* Experiment Name = 2015-04-13 171216
* Experiment Run End Time = 2015-04-13 18:07:57 PM PDT
...
[Amplification Data]
Well    Cycle    Target Name    Rn    Delta Rn
1    1    Adeno 1-Adeno 1    0.820    -0.051
1    2    Adeno 1-Adeno 1    0.827    -0.042
1    3    Adeno 1-Adeno 1    0.843    -0.025
1    4    Adeno 1-Adeno 1    0.852    -0.015
1    5    Adeno 1-Adeno 1    0.858    -0.008
1    6    Adeno 1-Adeno 1    0.862    -0.002
...
[Results]
Well    Well Position    Omit    Sample Name    Target Name    Task
Reporter    Quencher    RQ    RQ Min    RQ Max    CT    Ct Mean    Ct
SD    Quantity    Delta Ct Mean    Delta Ct SD    Delta Delta Ct
Automatic Ct Threshold    Ct Threshold    Automatic Baseline
Baseline Start    Baseline End    Efficiency    Comments    Custom1
Custom2    Custom3    Custom4    Custom5    Custom6    NOAMP
EXPFAIL
1    A1    false    P17    Adeno 1-Adeno 1    UNKNOWN    FAM
NFQ-MGB                Undetermined                            false
 0.200    true    3    44    1.000    N/A                            N
   Y
2    A2    false    P17    Adeno 40/41 EH-AIQJCT3    UNKNOWN    FAM
NFQ-MGB                Undetermined



More information about the R-help mailing list