AWK比较2档,2场不同的顺序中的文件,打印或合并匹配和不匹配行 [英] awk compare 2 files, 2 fields different order in the file, print or merge match and non match lines
问题描述
我有两个文件,我需要比较file1中的第二个字段,并从File2中的第一个字段。
如果有一个匹配,以打印从文件1匹配文件2的第二场和整个线
如果没有匹配打印找不到,并从文件1整条生产线
文件1
\\\\ FILESERV04 \\ PCO; S:\\ CA \\ USII ECOM; / FS7_434D / FILESERV04 / BUSII ;;;; \\\\ FILESERV04 \\ PCO \\; 467390611字节; 11225; 157
\\\\ FILESERV12 \\ $矿山; S:\\ CA \\纳卡; / FS3_434D / FILESERV12 / NAKA ;;;; \\\\ FILESERV12 \\矿山$ \\ 0字节; 0; 0
\\\\ FILESERV12 \\ $ INTEG; S:\\ CA \\ PLOTA; / FS3_434D / FILESERV12 / INTEG ;;;; \\\\ FILESERV12 \\ INTEG $ \\; 231094432158字节; 175180; 21309
\\\\ FILESERV15 \\ $ ED; S:\\ CA \\ ED; / FS3_434D / FILESERV12 / ED ;;;; \\\\ FILESERV15 \\ ED $ \\; 244594432158字节; 145040; 21311
文件2
取值:\\ CA \\ USII ECOM; 782
小号:\\ CA \\ PLOTA 0
小号:\\ CA \\纳卡; 781
所需的输出:
782; \\\\ FILESERV04 \\ PCO; S:\\ CA \\ USII ECOM; / FS7_434D / FILESERV04 / BUSII ;;;; \\\\ FILESERV04 \\ PCO \\; 467390611字节; 11225; 157
781; \\\\ FILESERV12 \\ $矿山; S:\\ CA \\纳卡; / FS3_434D / FILESERV12 / NAKA ;;;; \\\\ FILESERV12 \\矿山$ \\ 0字节; 0; 0
0; \\\\ FILESERV12 \\ $ INTEG; S:\\ CA \\ PLOTA; / FS3_434D / FILESERV12 / INTEG ;;;; \\\\ FILESERV12 \\ INTEG $ \\; 231094432158字节; 175180; 21309
NOT FOUND; \\\\ FILESERV15 \\ $ ED; S:\\ CA \\ ED; / FS3_434D / FILESERV12 / ED ;;;; \\\\ FILESERV15 \\ ED $ \\; 244594432158字节; 145040; 21311
如果该场数来比较是在这两个文件中相同的字段数量这条线的工作:
的awk -F; 'NR == FNR {a [$ 1] = $ 2;接下来} {如果(A [$ 1])打印[$ 1],$ 0;否则打印未找到; $ 0;}'文件1文件2
但是,因为在这种情况下,我有不同的场数从两个要比较的文件是不是在这里工作。
感谢
的awk -F; 'NR == FNR {a [$ 1] = $ 2;接下来} {如果(在$ 2)打印[$ 2],$ 0;否则打印未找到; $ 0;}'文件2文件1
I have two files, and I need to compare the second field from File1 and the first field from File2. If there is a match to print the second field of File2 and the entire line matched from File1 If there is no match to print "NOT FOUND" and the entire Line from File1
File1
\\FILESERV04\PCO;S:\CA\USII ECOM;/FS7_434D/FILESERV04/BUSII;;;;\\FILESERV04\PCO\;467,390,611 Bytes;11,225 ;157
\\FILESERV12\MINE$;S:\CA\Naka;/FS3_434D/FILESERV12/NAKA;;;;\\FILESERV12\MINE$\;0 Bytes;0 ;0
\\FILESERV12\INTEG$;S:\CA\PLOTA;/FS3_434D/FILESERV12/INTEG;;;;\\FILESERV12\INTEG$\;231,094,432,158 Bytes;175,180 ;21,309
\\FILESERV15\ED$;S:\CA\ED;/FS3_434D/FILESERV12/ED;;;;\\FILESERV15\ED$\;244,594,432,158 Bytes;145,040 ;21,311
File2
S:\CA\USII ECOM;782
S:\CA\PLOTA;0
S:\CA\Naka;781
Desired output:
782;\\FILESERV04\PCO;S:\CA\USII ECOM;/FS7_434D/FILESERV04/BUSII;;;;\\FILESERV04\PCO\;467,390,611 Bytes;11,225 ;157
781;\\FILESERV12\MINE$;S:\CA\Naka;/FS3_434D/FILESERV12/NAKA;;;;\\FILESERV12\MINE$\;0 Bytes;0 ;0
0;\\FILESERV12\INTEG$;S:\CA\PLOTA;/FS3_434D/FILESERV12/INTEG;;;;\\FILESERV12\INTEG$\;231,094,432,158 Bytes;175,180 ;21,309
NOT FOUND;\\FILESERV15\ED$;S:\CA\ED;/FS3_434D/FILESERV12/ED;;;;\\FILESERV15\ED$\;244,594,432,158 Bytes;145,040 ;21,311
If the field number to compare is the same field number on both files this line works:
awk -F";" 'NR==FNR{a[$1]=$2;next}{if (a[$1])print a[$1]";"$0;else print "Not Found"";" $0;}' File1 File2
But is not working here because in this case I have different field number to compare from both files.
Thanks
awk -F";" 'NR==FNR{a[$1]=$2;next}{if ($2 in a)print a[$2]";"$0;else print "Not Found"";" $0;}' File2 File1
这篇关于AWK比较2档,2场不同的顺序中的文件,打印或合并匹配和不匹配行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!