file1の最初の列とfile2の2番目の列を比較し、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