Sponsored Content
Top Forums Shell Programming and Scripting How to sort a field in a file having date values Post 302202095 by ripat on Wednesday 4th of June 2008 04:13:42 AM
Old 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


Last edited by ripat; 06-04-2008 at 05:19 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to Sort files on date field

: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)
Discussion started by: shivaastrogun
4 Replies

2. Shell Programming and Scripting

Sort two columns in a field, one of them being a date

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)
Discussion started by: sweta_doshi
5 Replies

3. Shell Programming and Scripting

how to sort date in decimal values uptp two digits

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)
Discussion started by: jojo123
3 Replies

4. UNIX for Dummies Questions & Answers

Sort field by date mm/dd/yyyy

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)
Discussion started by: csierra
6 Replies

5. Shell Programming and Scripting

Sorting Date Field with Sort -k :/

SOLVED : (17 Replies)
Discussion started by: Glitch100
17 Replies

6. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

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)
Discussion started by: rveri
3 Replies

7. Linux

How do I format a Date field of a .CSV file with multiple commas in a string field?

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

8. AIX

Sort by date field in AIX

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)
Discussion started by: Amit Joshi
2 Replies

9. Shell Programming and Scripting

Sort file by field 1 that has text as well as a number

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
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 Also
       folder(1mh)

																	sortm(1mh)
All times are GMT -4. The time now is 09:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy