Hi
I have a file like this:
XLOC_000001 q1:CUFF.307125|CUFF.307125.1|100|21.641774|12.337630|30.945918|15.184506|- -
XLOC_000001 q1:CUFF.307127|CUFF.307127.1|100|19.024629|10.301183|27.748076|13.490323|360 q2:CUFF.582701|CUFF.582701.2|35|4.177976|0.000000|9.502142|2.742783|628
XLOC_000002 q1:CUFF.307197|CUFF.307197.1|100|34.740054|22.951915|46.528193|22.054054|531 q2:CUFF.582841|CUFF.582841.1|100|67.322530|50.912469|83.732592|44.528017|608
XLOC_000005 q1:CUFF.307391|CUFF.307391.1|100|2.815540|0.000000|6.171455|1.981276|- -
XLOC_000007 q1:CUFF.307521|CUFF.307521.1|100|14.287217|6.727530|21.846904|10.184871|5318 q2:CUFF.583501|CUFF.583501.1|100|26.687891|16.355826|37.019955|18.473767|5806
XLOC_000011 q1:CUFF.307645|CUFF.307645.1|100|18.041098|9.546136|26.536061|11.601081|- -
XLOC_000389 - q2:CUFF.609345|CUFF.609345.1|100|18.703186|10.053750|27.352622|11.284938|-
XLOC_000391 - q2:CUFF.609367|CUFF.609367.1|50|13.973619|7.097039|20.850198|9.437297|-
XLOC_000392 - q2:CUFF.609367|CUFF.609367.2|39|10.916188|4.557339|17.275037|7.372414|-
I need to save those rows that has q1 or q2.(leave out those rows that contain both q1 and q2)
Anyone can help me? Thanks in advance
I have a file like this:
XLOC_000001 q1:CUFF.307125|CUFF.307125.1|100|21.641774|12.337630|30.945918|15.184506|- -
XLOC_000001 q1:CUFF.307127|CUFF.307127.1|100|19.024629|10.301183|27.748076|13.490323|360 q2:CUFF.582701|CUFF.582701.2|35|4.177976|0.000000|9.502142|2.742783|628
XLOC_000002 q1:CUFF.307197|CUFF.307197.1|100|34.740054|22.951915|46.528193|22.054054|531 q2:CUFF.582841|CUFF.582841.1|100|67.322530|50.912469|83.732592|44.528017|608
XLOC_000005 q1:CUFF.307391|CUFF.307391.1|100|2.815540|0.000000|6.171455|1.981276|- -
XLOC_000007 q1:CUFF.307521|CUFF.307521.1|100|14.287217|6.727530|21.846904|10.184871|5318 q2:CUFF.583501|CUFF.583501.1|100|26.687891|16.355826|37.019955|18.473767|5806
XLOC_000011 q1:CUFF.307645|CUFF.307645.1|100|18.041098|9.546136|26.536061|11.601081|- -
XLOC_000389 - q2:CUFF.609345|CUFF.609345.1|100|18.703186|10.053750|27.352622|11.284938|-
XLOC_000391 - q2:CUFF.609367|CUFF.609367.1|50|13.973619|7.097039|20.850198|9.437297|-
XLOC_000392 - q2:CUFF.609367|CUFF.609367.2|39|10.916188|4.557339|17.275037|7.372414|-
I need to save those rows that has q1 or q2.(leave out those rows that contain both q1 and q2)
Anyone can help me? Thanks in advance
Comment