sort columns by field

kamel.seg · #1 (**permalink**) 02-19-2008

hello,

i have a table contain many columns delimited by blank.

i want to sort this table by the 2 columns and 3 one and i want to keep the first line inchanged?
how can i do using the sort command?

thanks

table like :

field1 field2 field3 field4
x y z b
t h r n
..

jim mcnamara · #2 (**permalink**) 02-19-2008

sorting by columns 1 2 3 and keeping the first line in first place in file:

Code:

head -1 table > workingfile
awk 'NR>1' table | sort -k1.1,1.10 -k2.1,2.10 -k 23.1,3.10 >> workingfile

kamel.seg · #3 (**permalink**) 02-19-2008

thanks jim it works well

really when i post a question there only you to answer

i want to know something else if after this sort i want to suppress all but one occurrence of lines having the same second and third field?

kind regards

jim mcnamara · #4 (**permalink**) 02-19-2008

Code:

head -1 table > workingfile
awk 'NR>1' table | sort -k1.1,1.10 -k2.1,2.10 -k 23.1,3.10  | \
    awk '!arr[$2 $3]++' >> workingfile

remove duplicates on col2 and col 3.

kamel.seg · #5 (**permalink**) 02-20-2008

i try it but i get this error
arr[ : event not found

i put a space between ! and arr with no result.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
add columns from file to another and sort	kamel.seg	Shell Programming and Scripting	12	12-12-2007 02:39 PM
Help needed to sort multiple columns in one file	ahjiefreak	UNIX for Dummies Questions & Answers	1	12-07-2007 05:50 AM
find columns with whitespace as field seperator?	tkbharani	UNIX for Advanced & Expert Users	8	03-14-2007 01:13 AM
How do I specify tab as field separator for sort?	SSteve	UNIX for Dummies Questions & Answers	8	04-26-2005 05:39 PM
Sort by Columns	murbina	UNIX for Dummies Questions & Answers	1	05-10-2004 03:21 PM

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 Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by