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
*MSG5261445 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 .... . . .
*MSG5261512 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):
...
*MSG5261445 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*x5261445516.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 .... . . .
*MSG5261512 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:
...
*MSG5261445 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*x5261445516.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 .... . . .
*MSG5261512 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-tp3689025p3689025.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.
