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...
:cool:
Hi all,
I have a pecular issue in sorting these files in Solaris environment.
All the below files are modified on November 4th, but I want to sort these files as per date column (eg: 01May07_1623 = ddmmmyy_hhmm)
Nov 4 18:27 SONYELEC00.GI22973.01May07_1623.gpg
Nov 4 18:27... (4 Replies)
Hi,
I have a set of columns in a csv file, my first row being an integer and 2nd being a date. I want to first sort it using the first column and then by the second.
for e.g. i have ,
1234,09/05/2009,hi
5678,01/01/2008,hi
1234,11/03/2006,hello
5678,28/07/2010,hello
i tried this... (5 Replies)
Hi all,
there is a data in a file wich loks likes
00:00:49|24.48|
00:01:49|22.83|
00:02:49|22.07|
00:03:49|20.72|
00:04:49|21.28|
00:05:49|21.22|
00:06:49|21.38|
00:07:49|20.93|
00:08:49|21.27|
00:09:49|20.65|
00:10:49|19.42|
00:11:49|21.93|
00:12:49|20.62|
00:13:49|20.23|... (3 Replies)
Hello Group,
I would like to sort the below file by date (first year then month and day) and I used the following command but it does not work
sort -n -t"/" -k3 -k1 -k2
"sample original file"
12/28/2009,1.0353
12/31/2009,1.0357
12/30/2009,1.0364
12/29/2009,1.0366
12/24/2009,1.0386... (6 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)
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
I wanted to sort the below data on 4th field(comma seperator) based on month and date and time on AIX OS.
Input data:
3,AJ,30 Jul 06:30,30 Jul 06:30
5,AJ,30 Jul 06:30,30 Jul 06:49
10,AJ,30 Jul 06:30,02 Jan 05:41
4,AJ,30 Jul 06:30,30 Jul 06:36
2,AJ,30 Jul 06:30,28 Jul 06:45
9,AJ,30 Jul... (2 Replies)
I am using the below awk that results in the below output:
awk '{k=$1 OFS $2; s+=$4; c++} END{for(i in s) print i, s/c}' input.txt > output.txt output.txt
chr20:43625799-43625957 STK4:exon.6;STK4:exon.7 310.703
chr20:36770455-36770611 TGM2:exon.6;TGM2:exon.7 614.756... (5 Replies)
Discussion started by: cmccabe
5 Replies
LEARN ABOUT ULTRIX
sortm
sortm(1mh)sortm(1mh)Name
sortm - sort messages
Syntax
sortm [ msgs ] [ +folder ] [ options ]
Description
The command sorts all the messages in the current folder into chronological order according to the contents of the Date: fields of the mes-
sages.
By default, sorts all the messages in the current folder. You can select particular messages in the folder by giving a range of messages.
You can also sort messages in another folder by specifying the folder name.
If encounters a message without a Date: field, or if the message has a Date: field that cannot parse, it attempts to keep the message in
the same relative position. However, this does not always work; for instance, if the first message encountered lacks a date which can be
parsed, then it will usually be placed at the end of the messages being sorted.
When complains about a message which it cannot order, it complains about the message number prior to sorting.
Options-datefield field
Specifies the name of the header field to use when making the date comparison. If you have a special field in each message, such
as Delivery-Date:, then the -datefield switch can be used to tell which field to examine. If you do not give this option, the
default is to use the Date: header field.
-help Prints a list of all the valid options to this command.
-verbose
-noverbose
Displays the general actions that it is taking to place the folder in sorted order. The -noverbose option performs these actions
silently. The default is -noverbose.
The default settings for this command are:
+folder defaults to the current folder
msgs defaults to all
-datefield date
-noverbose
Profile Components
Path: To determine your MH directory
Examples
The following example sorts all the messages in the folder
% sortm +meetings
The next example sorts messages 10-30 in the folder called
% sortm +test 10-30
Files
The user profile.
See Alsofolder(1mh)sortm(1mh)