I'm afraid you need to convert the file to numeric months, then, sort it, and convert back. Try
Not sure this is the most elegant/efficient solution, though.
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 ... (4 Replies)
: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)
I want to sort alphabetically on the first field and sort in descending numerical order on the 2nd field. With a normal "sort -r -n" it does this:
abc ||| 5e-05 ||| bla
abc ||| 3 ||| ble
def ||| 1 ||| abc
def ||| 0.2 ||| def
As you can see it ignores the fact that 5e-05 is actually 0.00005... (1 Reply)
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)
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)
05.50.25:AIRE.S:RESTRICTED:S2:
05.50.25:ANDR.VI:RESTRICTED:S2:
05.50.25:BASF.MI:RESTRICTED:N:
05.50.25:BMWG.DE:RESTRICTED:N:
05.50.25:BORE.ST:RESTRICTED:N:
I can sort of the basis of second field using " sort -t: -k2,2 "
but what i want to sort the data is on the basis its extension e.g.:... (9 Replies)
I have a flatfile A.txt
2012/12/04 14:06:07 |trees|Boards 2, 3|denver|mekong|mekong12
2012/12/04 17:07:22 |trees|Boards 2, 3|denver|mekong|mekong12
2012/12/04 17:13:27 |trees|Boards 2, 3|denver|mekong|mekong12
2012/12/04 14:07:39 |rain|Boards 1|tampa|merced|merced11
How do i sort and get... (3 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)
Discussion started by: dhruuv369
3 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)