· 6 years ago · Jun 21, 2019, 04:20 PM
1Customer1 12345 12346 12347 15646
2Customer2 14444 14445
3
412345 aol.com
512347 gmail.com
612346 google.com
714444 yahoo.com
814445 outlook.com
915646 space.com
10
11Customer1 aol.com gmail.com google.com space.com
12Customer2 yahoo.com outlook.com
13
14awk 'NR==FNR {a[$1]=$2; next} $2 in a {print $0, a[$2]}' OFS='' file2.txt file1.txt
15
16$ awk 'NR==FNR {a[$1]=$2; next} {for (i=2;i<=NF;i++) $i = $i in a ? a[$i] : $i} 1' File2.txt File1.txt
17Customer1 aol.com google.com gmail.com space.com
18
19Customer2 yahoo.com outlook.com