merge based on common, awk help

jkl_jkl · #1 (**permalink**) 03-16-2008

All,

Code:

$ cat x.txt
z 11 az
x 12 ax
y 13 ay

$ cat y.txt
ay TT
ax NN

Output required:
y 13 ay TT
x 12 ax NN

yunccll · #2 (**permalink**) 03-16-2008

Code:

>cat x.txt
z 11 az
x 12 ax
y 13 ay
>cat y.txt
ay TT
ax NN

Code:

>sort x.txt > sx.tmp && sort y.txt > sy.tmp && join -1 3 -2 1 -o "1.1 1.2 1.3 2.2" sx.tmp sy.tmp | sort -r && rm -fr *.tmp
y 13 ay TT
x 12 ax NN

it's no need to use awk! using join is ok, :-) and how to use awk?

.Aaron

Franklin52 · #3 (**permalink**) 03-16-2008

Quote:

Originally Posted by yunccll

it's no need to use awk! using join is ok, :-) and how to use awk?

.Aaron

But you're using join, 3 times sort and 2 temporary files!

With awk:

Code:

awk 'NR==FNR{a[$1]=$2;next}$3 in a{print $0 a[$1]" "a[$3]}' y.txt x.txt

Regards

radoulov · #4 (**permalink**) 03-17-2008

If order matters:

Code:

awk 'NR==FNR{x[$3]=$0;next}$1 in x&&$0=x[$1] FS$2' x.txt y.txt

Use nawk or /usr/xpg4/bin/awk on Solaris.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
selecting only few lines from many based on a common pattern	damansingh	Shell Programming and Scripting	2	05-28-2008 06:29 AM
Common uses for Unix	rcengland	UNIX for Dummies Questions & Answers	4	04-11-2008 06:37 AM
Merge files based on key	sbasetty	Shell Programming and Scripting	3	02-02-2007 06:05 PM
is this a common problem in X?	3bumbs plumming	UNIX for Dummies Questions & Answers	3	12-06-2003 07:09 PM

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