Merge files based on key

sbasetty · #1 (**permalink**) 02-01-2007

Hi Friends,
Can any one help me with merging these file based on two columns :

File1:

A|123|99|SAMS
B|456|95|GEORGE
D|789|85|HOVARD

File2:
S|123|99|NANcY|6357
S|123|99|GREGRO|83748
A|456|95|HARRY|827|somers
S|456|95|ANTONY|546841|RUDOLPH|7263
B|456|95|SMITH|827|BOISE STATE|834
B|789|85|TIM|732643|NEW YORK|90723409

Output should be like this:
A|123|99|SAMS
S|123|99|NANcY|6357
S|123|99|GREGRO|83748
B|456|95|GEORGE
A|456|95|HARRY|827|somers
S|456|95|ANTONY|546841|RUDOLPH|7263
B|456|95|SMITH|827|BOISE STATE|834
D|789|85|HOVARD
B|789|85|TIM|732643|NEW YORK|90723409

Thanks in advance for your help.

S

reborg · #2 (**permalink**) 02-01-2007

if your sort has -m

Code:

sort -n -t\| -k2 -k3 -m file1 file2

else:

Code:

cat file1 file2 | sort -n -t\| -k2 -k3

sbasetty · #3 (**permalink**) 02-02-2007

sort -n -t\| -3 -5 -m file1 file2 ins not working.
is diplays the files seperately
I would like to merge that.

Thank you

reborg · #4 (**permalink**) 02-02-2007

You seem to be missing a couple of k's in your code.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
merge based on common, awk help	jkl_jkl	Shell Programming and Scripting	3	03-17-2008 07:13 AM
how to merge these two files?	fedora	Shell Programming and Scripting	3	02-12-2008 06:45 PM
merge files	koti_rama	Shell Programming and Scripting	5	12-24-2007 10:59 PM
use of sed over cat to merge files	miwinter	UNIX for Advanced & Expert Users	2	11-28-2007 01:36 PM
How to merge files	lestat_ecuador	Shell Programming and Scripting	3	06-07-2007 06:45 AM

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:


	Powered by