Hi,
The blunt answer is: by learning R. In particular, you will need pattern
matching techniques as in ?grep and (somewhat advanced, some would call it
basic) knowledge of R. So if you aren't familiar with either, I would
suggest an introductory manual or one of the many websites you find online
and then to dig deeper into the pattern matching stuff.
Generally, please adhere to the posting guide (provide a self-contained,
i.e., copy/paste-able, example of code/data for people to work with). Also,
you will be much more likely to receive a response if you have demonstrated
own coding effort (contributors are willing to solve problems but unwilling
to do other people's work).
Best,
Daniel
aRe wrote:
Hello together
I have a .txt file with about 1Mio! rows.
Sometimes the rows are in the following order (whereas the number of rows
between the rows marked with an x differ):
...
*SBLINK R 5261507*x
5261439 516.4 364.3 9148.0 ... 816.0 -1133.048.4
MA.C.TB...BL.
5261441 516.4 364.0 9145.0 ... 799.0 -1135.048.7
MA.C.TB...B..
5261443 516.4 363.9 9140.0 ... 817.0 -1171.049.3
MA.C.TB.R
*MSG 5261445 Prime 11_fe_ha*x
5261445 516.7 363.8 9133.0 ... 813.0 -1097.049.3
MA.C.TB..
5261447 517.0 363.8 9127.0 ... 818.0 -1144.049.9
MA.C.T.LRTB..
*EBLINK R 5261507 5261645 140*x
5261509 . .0.0 .... . .
.
5261511 . .0.0 .... . .
.
*MSG 5261512 Mask 8_ma_ma*x
5261513 . .0.0 .... . .
.
5261515 . .0.0 .... . .
.
...
Here I would like to generate an output, that gives me the two parts
...Prime 11_fe_ha and ...Mask 8_ma_ma if and only if ...Prime
11_fe_ha is situated between SBLINK... and EBLINK
Sometimes the rows are in the following order (whereas the number of rows
between the rows marked with an x differ):
...
*MSG 5261445 Prime 11_fe_ha*x
5261439 516.4 364.3 9148.0 ... 816.0 -1133.048.4
MA.C.TB...BL.
5261441 516.4 364.0 9145.0 ... 799.0 -1135.048.7
MA.C.TB...B..
5261443 516.4 363.9 9140.0 ... 817.0 -1171.049.3
MA.C.TB.R
*SBLINK R 5261507*x5261445 516.7 363.8 9133.0 ... 813.0 -1097.0
49.3 MA.C.TB..
5261447 517.0 363.8 9127.0 ... 818.0 -1144.049.9
MA.C.T.LRTB..
*EBLINK R 5261507 5261645 140*x
5261509 . .0.0 .... . .
.
5261511 . .0.0 .... . .
.
*MSG 5261512 Mask 8_ma_ma*x
5261513 . .0.0 .... . .
.
5261515 . .0.0 .... . .
.
...
Here I would like to generate an output, that consists of the two parts
...Prime 11_fe_ha and ...Mask 8_ma_ma if and only if SBLINK... is
situated between ... Prime 11_fe_ha and ...Mask 8_ma_ma. The place of
the EBLINK... is not important. that means also the following structure
should lead to the same output:
...
*MSG 5261445 Prime 11_fe_ha*x
5261439 516.4 364.3 9148.0 ... 816.0 -1133.048.4
MA.C.TB...BL.
5261441 516.4 364.0 9145.0 ... 799.0 -1135.048.7
MA.C.TB...B..
5261443 516.4 363.9 9140.0 ... 817.0 -1171.049.3
MA.C.TB.R
*SBLINK R 5261507*x5261445 516.7 363.8 9133.0 ... 813.0 -1097.0
5261447 517.0 363.8 9127.0 ... 818.0 -1144.049.9
MA.C.T.LRTB..
5261509 . .0.0 .... . .
.
5261511 . .0.0 .... . .
.
*MSG 5261512 Mask 8_ma_ma*x
5261513 . .0.0 .... . .
.
5261515 . .0.0 .... . .
.
*EBLINK R 5261507 5261645 140*x
...
can someone give me a advice how I could manage this task?
thanks
best
--
View this message in context:
http://r.789695.n4.nabble.com/analizing-txt-file-with-R-or-an-other-program-tp3689025p3689393.html
Sent from the R help mailing list archive at Nabble.com.
__
R-help@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.
