Revisions to grep, awk, sed, print column 2 matching in file1 and file2 column3

Tweeted twitter.com/StackUnix/status/765182138987806721

occurred Aug 15, 2016 at 13:43

added 10 characters in body

Source Link

edited Aug 15, 2016 at 13:04

113
6

edit: I would like to match column 21,2 of file1.txt with column of 31,3 of file2.txt and print the matching lines of file2.txt

file1.txt:

scaffold1   57482
scaffold1   63114
scaffold1   63118
scaffold1   63129
scaffold1   63139
scaffold1   63279
scaffold1   63294
scaffold2   65015
scaffold2   77268
scaffold2   77335

file2.txt:

scaffold1   381 382 T/A +
scaffold1   384 385 T/A,G   +
scaffold1   385 386 G/C +
scaffold1   445 446 C/T +
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

output.txt:

scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

I would like to match column 2 of file1.txt with column of 3 of file2.txt and print the matching lines of file2.txt

file1.txt:

scaffold1   57482
scaffold1   63114
scaffold1   63118
scaffold1   63129
scaffold1   63139
scaffold1   63279
scaffold1   63294
scaffold2   65015
scaffold2   77268
scaffold2   77335

file2.txt:

scaffold1   381 382 T/A +
scaffold1   384 385 T/A,G   +
scaffold1   385 386 G/C +
scaffold1   445 446 C/T +
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

output.txt:

scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

edit: I would like to match column 1,2 of file1.txt with column of 1,3 of file2.txt and print the matching lines of file2.txt

file1.txt:

scaffold1   57482
scaffold1   63114
scaffold1   63118
scaffold1   63129
scaffold1   63139
scaffold1   63279
scaffold1   63294
scaffold2   65015
scaffold2   77268
scaffold2   77335

file2.txt:

scaffold1   381 382 T/A +
scaffold1   384 385 T/A,G   +
scaffold1   385 386 G/C +
scaffold1   445 446 C/T +
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

output.txt:

scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

Fixed formatting and removed salutations and thanks, they're implied here

Source Link

edited Aug 15, 2016 at 12:30

terdon ♦

252.7k
69
481
719

I would like to match column 2 of file1.txt with column of 3 of file2.txt and print the matching lines of file2.txt

file1.txt:

file1.txt

scaffold1   57482
scaffold1   63114
scaffold1   63118
scaffold1   63129
scaffold1   63139
scaffold1   63279
scaffold1   63294
scaffold2   65015
scaffold2   77268
scaffold2   77335


 
file2.txt

file2.txt:

scaffold1   381 382 T/A +
scaffold1   384 385 T/A,G   +
scaffold1   385 386 G/C +
scaffold1   445 446 C/T +
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +
 
output.txt

output.txt:

scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

Appreciate your time and help.

Thank you

I would like to match column 2 of file1.txt with column of 3 of file2.txt and print the matching lines of file2.txt

file1.txt

scaffold1   57482
scaffold1   63114
scaffold1   63118
scaffold1   63129
scaffold1   63139
scaffold1   63279
scaffold1   63294
scaffold2   65015
scaffold2   77268
scaffold2   77335


 
file2.txt
scaffold1   381 382 T/A +
scaffold1   384 385 T/A,G   +
scaffold1   385 386 G/C +
scaffold1   445 446 C/T +
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +
 
output.txt
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

Appreciate your time and help.

Thank you

I would like to match column 2 of file1.txt with column of 3 of file2.txt and print the matching lines of file2.txt

file1.txt:

scaffold1   57482
scaffold1   63114
scaffold1   63118
scaffold1   63129
scaffold1   63139
scaffold1   63279
scaffold1   63294
scaffold2   65015
scaffold2   77268
scaffold2   77335

file2.txt:

scaffold1   381 382 T/A +
scaffold1   384 385 T/A,G   +
scaffold1   385 386 G/C +
scaffold1   445 446 C/T +
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

output.txt:

scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

blocquote -> code

Source Link

edit approved Aug 15, 2016 at 12:29

stderr

996
4
12

I would like to match column 2 of file1.txt with column of 3 of file2.txt and print the matching lines of file2.txt

file1.txt scaffold1 57482 scaffold1 63114 scaffold1 63118 scaffold1 63129 scaffold1 63139 scaffold1 63279 scaffold1 63294 scaffold2 65015 scaffold2 77268 scaffold2 77335

file2.txt scaffold1 381 382 T/A + scaffold1 384 385 T/A,G + scaffold1 385 386 G/C + scaffold1 445 446 C/T + scaffold1 57481 57482 T/A + scaffold1 63113 63114 T/A,G + scaffold1 63128 63129 G/C + scaffold2 65014 65015 G/A + scaffold2 77267 77268 G/A + scaffold2 77334 77335 C/T +

output.txt scaffold1 57481 57482 T/A + scaffold1 63113 63114 T/A,G + scaffold1 63128 63129 G/C + scaffold2 65014 65015 G/A + scaffold2 77267 77268 G/A + scaffold2 77334 77335 C/T +

file1.txt

scaffold1   57482
scaffold1   63114
scaffold1   63118
scaffold1   63129
scaffold1   63139
scaffold1   63279
scaffold1   63294
scaffold2   65015
scaffold2   77268
scaffold2   77335



file2.txt
scaffold1   381 382 T/A +
scaffold1   384 385 T/A,G   +
scaffold1   385 386 G/C +
scaffold1   445 446 C/T +
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

output.txt
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

Appreciate your time and help.

Thank you

I would like to match column 2 of file1.txt with column of 3 of file2.txt and print the matching lines of file2.txt

file1.txt scaffold1 57482 scaffold1 63114 scaffold1 63118 scaffold1 63129 scaffold1 63139 scaffold1 63279 scaffold1 63294 scaffold2 65015 scaffold2 77268 scaffold2 77335

file2.txt scaffold1 381 382 T/A + scaffold1 384 385 T/A,G + scaffold1 385 386 G/C + scaffold1 445 446 C/T + scaffold1 57481 57482 T/A + scaffold1 63113 63114 T/A,G + scaffold1 63128 63129 G/C + scaffold2 65014 65015 G/A + scaffold2 77267 77268 G/A + scaffold2 77334 77335 C/T +

output.txt scaffold1 57481 57482 T/A + scaffold1 63113 63114 T/A,G + scaffold1 63128 63129 G/C + scaffold2 65014 65015 G/A + scaffold2 77267 77268 G/A + scaffold2 77334 77335 C/T +

Appreciate your time and help.

Thank you

I would like to match column 2 of file1.txt with column of 3 of file2.txt and print the matching lines of file2.txt

file1.txt

scaffold1   57482
scaffold1   63114
scaffold1   63118
scaffold1   63129
scaffold1   63139
scaffold1   63279
scaffold1   63294
scaffold2   65015
scaffold2   77268
scaffold2   77335



file2.txt
scaffold1   381 382 T/A +
scaffold1   384 385 T/A,G   +
scaffold1   385 386 G/C +
scaffold1   445 446 C/T +
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

output.txt
scaffold1   57481   57482   T/A +
scaffold1   63113   63114   T/A,G   +
scaffold1   63128   63129   G/C +
scaffold2   65014   65015   G/A +
scaffold2   77267   77268   G/A +
scaffold2   77334   77335   C/T +

Appreciate your time and help.

Thank you

Source Link

asked Aug 15, 2016 at 12:25

kapr0001

113
6

Loading

Stack Exchange Network

Return to Question