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

관련 정보