nixCraft

cucu81 · #1 (**permalink**) 07-24-2006, 02:10 PM

Hi,

I am a newbie to shell scripting. I am tasked to sort a file based on some fields.

For example:

(1) (2) (3)
Japan 20 Air
Malaysia 21 Land

I will need to sort the 2 records within the file test.txt based on field(1) first and then field(2). This is similar to SQL where we order by (1),(2)

Can someone advise me on how to do that using shell scripting or awk? Its very urgent. thanks a million in advance

chimu · #2 (**permalink**) 07-25-2006, 04:08 AM

Use sort command:

Code:

sort -k +1,+2  /path/to/file

if you are using old UNIX version try

Code:

sort +1 +2 /path/to/file

read man page of sort for more

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to match two fields	Prahlad	Shell scripting	3	04-09-2008 01:58 PM
need help to install FreeBSD 6 series on my Intel based pc	sneezycrazyturtle	All about FreeBSD/OpenBSD/NetBSD	1	02-22-2007 03:27 PM
script finding file and sorting	dementeddude	Shell scripting	14	07-25-2006 06:30 PM
Apache multiple IP based domains and one certificate	tom	All about FreeBSD/OpenBSD/NetBSD	1	06-26-2006 08:23 PM
moving files based on size	kavi	Shell scripting	2	11-11-2005 06:17 PM

nixCraft

Sorting individual records in a file based on some fields

Sorting individual records in a file based on some fields

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads