<![CDATA[BOL: Extract the values using ids !]]> https://bioinformaticsonline.com/snippets/view/43603/extract-the-values-using-ids? https://bioinformaticsonline.com/snippets/view/43603/extract-the-values-using-ids Mon, 22 Nov 2021 20:07:29 -0600 https://bioinformaticsonline.com/snippets/view/43603/extract-the-values-using-ids <![CDATA[Extract the values using ids !]]> #Awk script awk 'NR==FNR{tgts[$1]; next} $1 in tgts' file1 file2 Look: $ cat file1 11002 10995 48981 79600 $ cat file2 10993 item 0 11002 item 6 10995 item 7 79600 item 7 439481 item 5 272557 item 7 224325 item 7 84156 item 6 572546 item 7 693661 item 7 $ awk 'NR==FNR{tgts[$1]; next} $1 in tgts' file1 file2 11002 item 6 10995 item 7 79600 item 7]]> Surabhi Chaudhary https://bioinformaticsonline.com/snippets/view/43603/extract-the-values-using-ids#item-annotation-4014 Mon, 22 Nov 2021 20:09:18 -0600 https://bioinformaticsonline.com/snippets/view/43603/extract-the-values-using-ids#item-annotation-4014 <![CDATA[Comment by Surabhi Chaudhary]]> Join could be also useful

linux_prompt> join file1 file2
11002 item 6
10995 item 7
79600 item 7
]]> Surabhi Chaudhary