Awk Compare f1,f2,f3 of File1 with f1 of File2

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Awk Compare f1,f2,f3 of File1 with f1 of File2

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Search, replace string in file1 with string from (lookup table) file2?	gstuart	Shell Programming and Scripting	9	06-08-2009 07:11 AM
insert file2 after line containing patternX in file1	repudi8or	Shell Programming and Scripting	5	04-18-2008 02:35 PM
match value from file1 in file2	myguess21	Shell Programming and Scripting	2	02-21-2008 11:39 AM
echo "ABC" > file1.txt file2.txt file3.txt	ganapati	UNIX for Dummies Questions & Answers	4	01-30-2008 12:36 AM
delete lines from file2 beginning w/file1	michieka	Shell Programming and Scripting	13	06-24-2003 02:42 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

11-08-2007

RacerX

Registered User

Join Date: Oct 2007

Posts: 38

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

Bookmarks

« check position of end of line for some specific lines | remove lines from file »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 06:39 AM.