天天看點

awk實作兩個檔案中資料集求同異

1.在B中同時也在A中,comm_a_b.sh

sort -nu A > /tmp/A.txt

sort -nu B > /tmp/B.txt

awk 'NR==FNR{a[$1]=$2} NR>FNR {if($1 in a){print $0}}' /tmp/A.txt /tmp/B.txt > /tmp/result.txt

2.在B中,不在A中,diff_in_b_not_in_a.sh

sort -nu A > /tmp/A.txt

sort -nu B > /tmp/B.txt

awk 'NR==FNR{a[$1]=$2} NR>FNR {if(!($1 in a)){print $0}}' /tmp/A.txt /tmp/B.txt > /tmp/result.txt

繼續閱讀