How to sort a field in a file having date values

risshanth · #1 (**permalink**) 06-04-2008

Hi All,

I am having a pipe delimited file .In this file the 3rd column is having date values.I need to get the min date and max date from that file.

I have used
cut -d '|' test.dat -f 3|sort -u

But it is not sorting the date .How to sort the date column using unix commands

Thanks
Deepak

zaxxon · #2 (**permalink**) 06-04-2008

Show us some lines of your delimeted file, please.

risshanth · #3 (**permalink**) 06-04-2008

I have used a small file for testing

A line in the file looks like thsi
deepak|55445|12-02-2008|alappuzha

ripat · #4 (**permalink**) 06-04-2008

The problem with your file is that the date is not ISO i.e. it is not sortable as it is. You have to split it and sort it first on the YYYY, then on MM and, finaly on DD. That's exactly what the following command does. It sorts on the 3rd field from character 7 to character 10 then on char. 4 to 5 etc...

Code:

sort -u -t"|" -k 3.7,3.10n -k 3.4,3.5n -k 3.1,3.2n file

risshanth · #5 (**permalink**) 06-04-2008

Thanks a lot ...

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
read from a file and calculate values for a specified field	lucho_1	Shell Programming and Scripting	3	03-11-2008 07:24 PM
how to sort paragraphs by date within a file	nabmufti	Shell Programming and Scripting	1	02-13-2008 05:33 PM
loop through the directory for files and sort by date and process the first file	dsdev_123	AIX	1	01-30-2008 05:31 PM
sort a file by date using perl	esham	Shell Programming and Scripting	4	04-14-2005 01:04 PM

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: