☰

使用 awk 进行列比较

tag-icon • tag-icon command-line text-processing awk
使用 awk 进行列比较

我想将 file1 的第一列与 file2 的第二列进行比较，只有当它们匹配时，才应将 file2 中的任何匹配行显示为输出。列之间用 分隔|。

file1:

syfar03040k16.audc1.oraclecloud.com |
syfar03040m02.audc1.oraclecloud.com |
syfar03040m04.audc1.oraclecloud.com |
syfar03040n11.audc1.oraclecloud.com |
syfar03040n01.audc1.oraclecloud.com |
syfar03040n02.audc1.oraclecloud.com |
syfar03040n03.audc1.oraclecloud.com |
syfar03040n05.audc1.oraclecloud.com |
syfar03040n07.audc1.oraclecloud.com |
syfar03040o11.audc1.oraclecloud.com |
syfar03040o01.audc1.oraclecloud.com |
syfar03040o02.audc1.oraclecloud.com |
syfar03040o03.audc1.oraclecloud.com |
syfar03040o13.audc1.oraclecloud.com |
syfar03040o05.audc1.oraclecloud.com |
syfar03040o04.audc1.oraclecloud.com |
syfar03040o16.audc1.oraclecloud.com |

file2:

   | LDAP                 | syfar03040o11.audc1.oraclecloud.com               |
   | OIM                  | syfar03040o01.audc1.oraclecloud.com               |
   | AUTHOHS              | syfar03040o02.audc1.oraclecloud.com               |
   | APPOHS               | syfar03040o03.audc1.oraclecloud.com               |
   | BI                   | syfar03040o04.audc1.oraclecloud.com               |
   | ADMIN                | syfar03040o05.audc1.oraclecloud.com               |
   | PRIMARY              | syfar03040o06.audc1.oraclecloud.com               |
   | SECONDARY            | syfar03040o07.audc1.oraclecloud.com               |
   | APPOHS_HA1           | syfar03040o13.audc1.oraclecloud.com               |
   | PRIMARY_HA1          | syfar03040o16.audc1.oraclecloud.com               |
   | SECONDARY_HA1        | syfar03040o17.audc1.oraclecloud.com               |
   | OSN                  | syfar03040o09.audc1.oraclecloud.com               |

File3:

   | LDAP                 | syfar03040o11.audc1.oraclecloud.com               |
   | OIM                  | syfar03040o01.audc1.oraclecloud.com               |
   | AUTHOHS              | syfar03040o02.audc1.oraclecloud.com               |
   | APPOHS               | syfar03040o03.audc1.oraclecloud.com               |
   | BI                   | syfar03040o04.audc1.oraclecloud.com               |
   | ADMIN                | syfar03040o05.audc1.oraclecloud.com               |
   | APPOHS_HA1           | syfar03040o13.audc1.oraclecloud.com               |
   | PRIMARY_HA1          | syfar03040o16.audc1.oraclecloud.com               |

答案1

awk '
    NR == FNR {
        file1[$1] = 1;
        next;
    }
    $4 in file1 {
        print $0;
    }
' file1 file2

相关内容