As I understand your problem, you want to sort the file on the colored date fields don't you?
Code:
Sat 12 Sep 2009 10:31:49 PM MYT;a;a;a;Sun 13 Sep 2009 11:32:49 AM MYT;
Sat 13 Sep 2009 10:31:49 PM MYT;a;a;a;Mon 14 Sep 2009 10:31:49 PM MYT;
Sat 14 Sep 2009 10:31:49 PM MYT;a;a;a;Sun 13 Sep 2009 10:31:49 PM MYT;
If this is the case, you are in trouble with the sort command as it doesn't sort on plain text dates AFAIK.
So, first you have to loop through your file and convert the date field into some sort of ISO date format like 2009-09-13 21:15:07 and than, pipe it into sort.
Or use awk with this suggestion:
Code:
# sortdate.awk
BEGIN{
FS=OFS=";"
months="Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec"
split(months, m, " ")
for (i in m) mm[m[i]]=i
}
{
split($5, dte, " ")
split(dte[5], time, ":")
dteKey=sprintf("%s%02d%s%s%s%s",dte[4],mm[dte[3]],dte[2],(dte[6]=="PM")?time[1]+12:time[1],time[2],time[3])
record[dteKey$0]=$0
sortKey[NR]=dteKey$0
}
END{
n=asort(sortKey)
for(i=1;i<=n;i++) print record[sortKey[i]]
}
I'm looking to edit a file which contains various data including date.(ddmmyyyy)
I want to sort by date and then count the number of different dates found
Any ideas how to acheive this
Thanks in advance. (2 Replies)
Hi ,
I have written a shell script that takes the current date on the server and stores it in a file.
echo get /usr/home/data-`date '+%Y%d'`.xml> /usr/local/sandeep/GetFILE.ini
I call this GetFILE.ini file from an sftp program to fetch a file from /usr/home/ as location. The file is in... (3 Replies)
Hello World~
Please Help Me(BASH)
input:
dde,2007.8.25,891
dde,2007.8.23,356
dfe,2007.10.12,341
cba,2005.12.5,342
I wanna know how to sort by the date(2005.12.5)
output:
cba,2005.12.5,342
dde,2007.8.23,356
dde,2007.8.25,891
dfe,2007.10.12,341
Thanks in advance (3 Replies)
Hi Guys ,
Please help me I am having a requirement as below:
$ ls -i log* | head
66486532 log1
66486662 log10
66486663 log11
66486664 log12
66486665 log13
66486533 log2
66486534 log3
66486535 log4
66486584 log5
66486590 log6
This id listing the first 10 files starting with log.
... (4 Replies)
these are two records(adr.txt)trying to sort with the the code expl below.
5423|336110|2730 Pierce St|Ste 300|Sioux City|IA|Woodbury|51104|3765||42518651|96405013|A|2|3|U|12/08/2009
5423|14462335|624 JONES ST|STE 5400|Sioux City|IA|Woodbury|51101|||42496648|96400644|A|8|2|U |12/24/2009
nawk... (3 Replies)
The problem:
I have a task to give a my boss:
1. the files and directory sizes in human readable form: du -h
2. He also wants me to give him the date stamp on the files and directories. something like ls -R or sort by date
Does anyone have a script that can do this efficiently (I am... (2 Replies)
Hi All,
I am trying to sort the below data using sort command.
temp.dat
H|S1-511091486889|27-Jul-2011 00:00:00
H|S1-511091486823|27-Jul-2011 00:00:00
H|S1-511091486757|27-Jul-2011 00:00:00
L|S1-511091486889|1
L|S1-511091486823|1
L|S1-511091486757|1
sort -t "|" -k2 -k1 temp.dat
My... (5 Replies)
Hi Experts,
I have a filelist collected from another server , now want to sort the output using date/time stamp filed.
- Filed 6, 7,8 are showing the date/time/stamp.
Here is the input:
#----------------------------------------------------------------------
-rw------- 1 root ... (3 Replies)
nawk '$1=="Date" {d=$(NF-2);next} $1=="Queue" {q=$NF;next} $1=="Forms"{print q, $NF, d}' OFS='|' printfile.log
I have this script working. Please let me know how to sort by Queue and then Date. (4 Replies)
Discussion started by: Daniel Gate
4 Replies
LEARN ABOUT MINIX
sort
SORT(1) General Commands Manual SORT(1)NAME
sort - sort a file of ASCII lines
SYNOPSIS
sort [-bcdfimnru] [-tc] [-o name] [+pos1] [-pos2] file ...
OPTIONS -b Skip leading blanks when making comparisons
-c Check to see if a file is sorted
-d Dictionary order: ignore punctuation
-f Fold upper case onto lower case
-i Ignore nonASCII characters
-m Merge presorted files
-n Numeric sort order
-o Next argument is output file
-r Reverse the sort order
-t Following character is field separator
-u Unique mode (delete duplicate lines)
EXAMPLES
sort -nr file # Sort keys numerically, reversed
sort +2 -4 file # Sort using fields 2 and 3 as key
sort +2 -t: -o out # Field separator is :
sort +.3 -.6 # Characters 3 through 5 form the key
DESCRIPTION
Sort sorts one or more files. If no files are specified, stdin is sorted. Output is written on standard output, unless -o is specified.
The options +pos1 -pos2 use only fields pos1 up to but not including pos2 as the sort key, where a field is a string of characters delim-
ited by spaces and tabs, unless a different field delimiter is specified with -t. Both pos1 and pos2 have the form m.n where m tells the
number of fields and n tells the number of characters. Either m or n may be omitted.
SEE ALSO comm(1), grep(1), uniq(1).
SORT(1)