Sorting the records in the Flat file

sudhir_barker · #1 (**permalink**) 01-05-2009

Hi all,

I am using this command "sort -d -u -k1 IMSTEST.74E -o tmp.txt" to the records in the flat.

Can any tell me how to sort the file except first line in the file

For ex:
i/p
First line: DXYZ
Second line : jumy
third : cmhk
fourth : andy

Output should be:
DXYZ
andy
cmhk
jumy

Thanks In Advance
Sudhir

pludi · #2 (**permalink**) 01-05-2009

Code:

head -n 1 IMSTEST.74E > tmp.txt
tail -n +2 IMSTEST.74E > main.txt
sort -d -u -k1 main.txt >> tmp.txt
rm main.txt

ssachins · #3 (**permalink**) 01-05-2009

You can use only 'sort tmp.txt'. It should work fine.

summer_cherry · #4 (**permalink**) 01-06-2009

Code:

#! /usr/bin/perl
open FH,"<a.txt";
while(<FH>){
	chomp;
	my @tmp=split(":",$_);
	push @arr,$tmp[1]."\n";
}
print $arr[0],sort @arr[1..$#arr];

frostmourn · #5 (**permalink**) 01-06-2009

Code:

head -1 file >tmp.txt&&sed '1d' file|sort -d -u -k1 >>tmp.txt

Franklin52 · #6 (**permalink**) 01-06-2009

Or simply with awk:

Code:

awk '{print $NF|"sort"}' file

Regards

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to delimit a flat file with records with SED	RogCor	Shell Programming and Scripting	4	10-28-2008 01:18 PM
Records mismatch while sorting in MPRAS and SunOS	RRVARMA	UNIX for Advanced & Expert Users	1	07-02-2008 08:18 AM
Count No of Records in File without counting Header and Trailer Records	guiguy	Shell Programming and Scripting	2	06-07-2007 12:15 PM
Inserting records from flat file to db table	Hara	Shell Programming and Scripting	4	12-27-2006 03:35 AM
Sorting a flat file based on multiple colums(using character position)	cucubird	Shell Programming and Scripting	8	07-25-2006 12:47 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: