merge two files in ascending order - Page 2

		The UNIX and Linux Forums > Top Forums > UNIX for Advanced & Expert Users
merge two files in ascending order

google unix.com

UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Ascending order within text	kerpm	Shell Programming and Scripting	5	08-15-2008 10:39 AM
Display modified files in ascending order	balareddy	UNIX for Advanced & Expert Users	1	08-13-2008 06:48 AM
Ascending & Descending order numbers	pravani1	Shell Programming and Scripting	6	06-03-2008 08:43 AM
use of sed over cat to merge files	miwinter	UNIX for Advanced & Expert Users	2	11-28-2007 01:36 PM
Sort / ascending order	gyik	UNIX for Dummies Questions & Answers	1	03-05-2001 10:08 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

09-03-2008

user_prady user_prady is offline

Registered User

Join Date: Sep 2007

Posts: 163

merge two files in ascending order

Hello Friends,

I want to merge two files in ascending order on the first field. And if the first field matches sort on 3rd field i.e, TXADDR should come ahead of RXADDR .

file1

Code:

      9 : TXADDR  : 00000000
     65 : TXDATA  0000000000000011
     83 : TXDATA  0000000000000012
    453 : TXADDR  : 00000000
    509 : TXDATA  0000000000000001
    527 : TXDATA  0000000000000002
    879 : TXADDR  : 00000020
     934 : TXDATA  0000000000000011
     953 : TXDATA  0000000000000012
     971 : TXDATA  0000000000000013

file2

Code:


        9 : RXADDR  : 00000001
      65 : RXDATA  0000000000000011
      83 : RXDATA  0000000000000012
     102 : RXDATA  0000000000000013
     453 : RXADDR  : 00000000
     509 : RXDATA  0000000000000001
     527 : RXDATA  0000000000000002
     546 : RXDATA  0000000000000003
     879 : RXADDR  : 00000020
     934 : RXDATA  0000000000000011
     953 : RXDATA  0000000000000012
     971 : RXDATA  0000000000000013
     990 : RXDATA  0000000000000014

WIth the below command I able to sort and merge on the first field.

Code:

sort -n file1 file2 > file3

In file3 I expect when the first column matches it should give priority to the 3rd column i.e RXADDR & RXDATA.
So in my case the output should be

Code:

      9 : TXADDR  : 00000000
      9 : RXADDR  : 00000001
    65 : TXDATA  0000000000000011
    65 : RXDATA  0000000000000011

I dont know how sort with multiple key with sort pls suggest a option for that. or any other soln.

Regards,
user_prady

Last edited by user_prady; 09-04-2008 at 01:17 AM..

Bookmarks

« Grep all the columns based on a particular column | How to configure Linux box with my SMTP mail server »

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 12:58 AM.