|
Awk Compare f1,f2,f3 of File1 with f1 of File2
I have an Awk string-compare problem and have searched the internet and forums for a solution i could use but cannot find a solution i understand to make work with my particular problem:
I need to compare (field1 field2 field3 of File1) against (field1 of File2) and if they match print out (field1:field2:field3) of File1 followed by field2 of File2 and field3 of File2. In the case of no-match exists in File2, just print out the (field1:field2:field3 of File1).
File1
Code:
RICHARD:J:LOONEY
JAMES:F:BIXLER
JED:H:YOUNG
LEWIS:A:ZAPP
SILAS: :VECINIO
DERICK:S:HOLMER
MICK: :REZNIC
R: :BAKER
HERROD:G:LOST
OLIVE:N:TORROSSI
JASPER:G:WILCOX
AUDREY:H:VIKING
File2
Code:
RICHARD J LOONEY:YONKERS:NY
JAMES F BIXLER:LEXINGTON:KY
JED H YOUNG:SURREY:BC
LEWIS A ZAPP:GREEN VALLEY:CA
SILAS VECINIO:COLUMBUS:OH
DERICK S HOLMER:WESTFORD:MA
MICK REZNIC:AKRON:OH
R BAKER:AUCKLAND:NEW ZEALAND
OLIVE N TORROSSI:DAVISON:MI
LEWIS A ZAPP:GREEN VALLEY:CA
JASPER G WILCOX:CANTON:OH
AUDREY H VIKING:SURREY:BC
DESIRED OUTPUT
Code:
RICHARD:J:LOONEY:YONKERS:NY
JAMES:F:BIXLER:LEXINGTON:KY
JED:H:YOUNG:SURREY:BC
LEWIS:A:ZAPP:GREEN VALLEY:CA
SILAS: :VECINIO:COLUMBUS:OH
DERICK:S:HOLMER:WESTFORD:MA
MICK: :REZNIC:AKRON:OH
R: :BAKER:AUCKLAND:NEW ZEALAND
HERROD:G:LOST
OLIVE:N:TORROSSI:DAVISON:MI
JASPER:G:WILCOX:CANTON:OH
AUDREY:H:VIKING:SURREY:BC
|