How to Sort by Date and Time?

Login or Register to Ask a Question and Join Our Community

How to Sort by Date and Time?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to Sort by Date and Time?

10-27-2012

Registered User

27, 0

Join Date: Aug 2012

Last Activity: 23 May 2014, 8:53 AM EDT

Posts: 27

Thanks Given: 9

Thanked 0 Times in 0 Posts

How to Sort by Date and Time?

Hi,

The input file is as follows,

Code:

22.06.2012 17:58:38 CPUser: xxxxxxx, billedAfterStatus: Active
13.07.2012 08:46:15 CPUser: xxxxxxx, billedAfterStatus: Active
20.07.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active
20.03.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active
20.05.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active

and we need output a follows,

Code:

20.03.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active
20.05.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active
22.06.2012 17:58:38 CPUser: xxxxxxx, billedAfterStatus: Active
13.07.2012 08:46:15 CPUser: xxxxxxx, billedAfterStatus: Active
20.07.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active

which command i have to use?

Please Suggest me.

Regards,
Nanthagopal A

Last edited by Scrutinizer; 10-27-2012 at 07:43 AM.. Reason: code tags

nanthagopal

View Public Profile for nanthagopal

Find all posts by nanthagopal

10-27-2012

Moderator

3,689, 1,352

Join Date: Jan 2012

Last Activity: 22 August 2020, 11:29 PM EDT

Location: Galactic Empire

Posts: 3,689

Thanks Given: 268

Thanked 1,352 Times in 1,258 Posts

For above input, you can try the below command:-

Code:

sort -t'.' -k2.2 -k1.2 file

These 2 Users Gave Thanks to Yoda For This Post:

Yoda

View Public Profile for Yoda

Visit Yoda's homepage!

Find all posts by Yoda

10-27-2012

Registered User

440, 71

Join Date: Oct 2009

Last Activity: 26 June 2018, 6:52 PM EDT

Location: spaceBAR Central

Posts: 440

Thanks Given: 0

Thanked 71 Times in 70 Posts

You can do it with the 'sort' command:

Code:

$ sort -k 1.7n,1.10n -k 1.4n,1.5n -k 1.1n,1.2n -k 2.1n,2.2n -k 2.4n,2.5n -k 2.7n,2.8n t
20.03.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active
20.05.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active
22.06.2012 17:58:38 CPUser: xxxxxxx, billedAfterStatus: Active
13.07.2012 08:46:15 CPUser: xxxxxxx, billedAfterStatus: Active
20.07.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active

This User Gave Thanks to spacebar For This Post:

spacebar

View Public Profile for spacebar

Find all posts by spacebar

10-27-2012

Registered User

27, 0

Join Date: Aug 2012

Last Activity: 23 May 2014, 8:53 AM EDT

Posts: 27

Thanks Given: 9

Thanked 0 Times in 0 Posts

Quote:

Originally Posted by bipinajith

For above input, you can try the below command:-

Code:

sort -t'.' -k2.2 -k1.2 file

I have used the above code and got the result in sorted order as below.

Code:

08.05.2012 10:52:32 User: xxxx
15.05.2012 11:30:38 User: xxxx
22.05.2012 11:56:39 User: xxxx
29.05.2012 16:33:04 User: xxxx
19.06.2012 10:51:55 User: xxxx
26.06.2012 11:04:27 User: xxxx
12.06.2012 14:40:27 User: xxxx
05.06.2012 20:46:18 User: xxxx
18.07.2012 03:13:16 User: xxxx

but, the exact output would be like this,

Code:

08.05.2012 10:52:32 User: xxxx
15.05.2012 11:30:38 User: xxxx
22.05.2012 11:56:39 User: xxxx
29.05.2012 16:33:04 User: xxxx
05.06.2012 20:46:18 User: xxxx
12.06.2012 14:40:27 User: xxxx
19.06.2012 10:51:55 User: xxxx
26.06.2012 11:04:27 User: xxxx
18.07.2012 03:13:16 User: xxxx

so, how to change the

Code:

sort -t'.' -k2.2 -k1.2

code and also
explain the above code.

Regards,
Nanthagopal A

Last edited by Scrutinizer; 10-27-2012 at 07:44 AM.. Reason: code tags

nanthagopal

View Public Profile for nanthagopal

Find all posts by nanthagopal

10-27-2012

Registered User

177, 61

Join Date: Mar 2012

Last Activity: 2 November 2013, 1:26 AM EDT

Location: In books/UNIX.com

Posts: 177

Thanks Given: 16

Thanked 61 Times in 60 Posts

Code:

sort -t"."  -k3.1,3.4n -k2,2n -k1,1n temp

But this sorts for only years,months,days..let me know if you want to dig into time also..

And yeah, Spacebar's code is working great for even time..you can use that also

msabhi

View Public Profile for msabhi

Find all posts by msabhi

10-27-2012

Registered User

27, 0

Join Date: Aug 2012

Last Activity: 23 May 2014, 8:53 AM EDT

Posts: 27

Thanks Given: 9

Thanked 0 Times in 0 Posts

Quote:

Originally Posted by msabhi

Code:

sort -t"."  -k3.1,3.4n -k2,2n -k1,1n temp

But this sorts for only years,months,days..let me know if you want to dig into time also..

And yeah, Spacebar's code is working great for even time..you can use that also

No, i don't need for time. Now it's working fine.
Thank you for your reply.

Code:

sort -t"."  -k3.1,3.4n -k2,2n -k1,1n

Could you please explain the above code.

Regards,
Nanthagopal A

nanthagopal

View Public Profile for nanthagopal

Find all posts by nanthagopal

10-27-2012

Registered User

177, 61

Join Date: Mar 2012

Last Activity: 2 November 2013, 1:26 AM EDT

Location: In books/UNIX.com

Posts: 177

Thanks Given: 16

Thanked 61 Times in 60 Posts

Code:

-t "."

this option stands for identifying delimiter and here its dot

Code:

-k3.1,3.4n

"k start,stop" stands for field to start and stop at...first am sorting on years which happens to be 3rd column..so 3.1 means third column first character until fourth character..
same applies for all the other "k" options...where second is for sorting on months and then sorting on days...

Quote:

Originally Posted by nanthagopal

No, i don't need for time. Now it's working fine.
Thank you for your reply.

Code:

sort -t"."  -k3.1,3.4n -k2,2n -k1,1n

Could you please explain the above code.

Regards,
Nanthagopal A

This User Gave Thanks to msabhi For This Post:

msabhi

View Public Profile for msabhi

Find all posts by msabhi

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort date time in ascending order

Hi, i had a data block (coming from pipe from other codes) as: H YF_CO.dat 77164 11/17/2013 04:00:02 731374590.96 1 1 731374590.96 76586 77164 578 2988 Y H YF_CO.dat 77164 11/17/2013 04:00:07 731374590.96 1 4 731374590.96 76586 77164 578 2988 Y H YF_CO.dat 77178 ...

2. 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. Shell Programming and Scripting

Displaying current date time of EDT in IST time

Hi Folks, My server time is in EDT. And i am sending automated mails from that server in which i need to display the current date time as per IST (GMT+5:30). Please advice how to display the date time as per IST. IST time leads 9:30 mins to EDT. and i wrote something like below. ...

4. Shell Programming and Scripting

Help with sort word and general numeric sort at the same time

Input file: 100%ABC2 3.44E-12 USA A2M%H02579 0E0 UK 100%ABC2 5.34E-8 UK 100%ABC2 3.25E-12 USA A2M%H02579 5E-45 UK Output file: 100%ABC2 3.44E-12 USA 100%ABC2 3.25E-12 USA 100%ABC2 5.34E-8 UK A2M%H02579 0E0 UK A2M%H02579 5E-45 UK Code try: sort -k1,1 -g -k2 -r input.txt...

5. Shell Programming and Scripting

Adding time to date time in UNIX shell scipting

I needed some help in adding a duration (in seconds) to a start time (in hhmmss format) and a start date (in mmddyy format) in order to get an end date and end time. The concept of a leap year is also to be considered while incrementing the day. The code/ function that I have formed so far is as...

6. Solaris

modifying date and time and time zone on solaris 5.10 with (redundant server) veritas

I have a cluster of two Solaris server (veritas cluster). one working and the other is standby I am going to change the date on them , and am looking for a secure solution as it is giving an important service. my opinion is that the active one doesn't need to be restarted (if I don't change the...

7. UNIX for Dummies Questions & Answers

Converting string date time to unix time in AWK

I'd like to convert a date string in the form of sun aug 19 09:03:10 EDT 2012, to unixtime timestamp using awk. I tried This is how each line of the file looks like, different date and time in this format Sun Aug 19 08:33:45 EDT 2012, user1(108.6.217.236) all: test on the 17th ...

8. Shell Programming and Scripting

shell script to sort entries in a file by date and time

Hello All, Need a shell script to sort entries in a file by date and time. Below are the entries in the file, i need to sort it first by the date and then time Note :- Date is in MM/DD/YY format and date comes as the 6th & time comes on 7th coloumns respectively. 150 pbnawldb001-b...

9. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their...

10. Shell Programming and Scripting

Sort By Date and Time

Hi , I would like to list or sort by date and time (the files are named in day and time format) where the latest file will be placed at the bottom and the earliest file be placed at the top. Can anybody help me? My files are named in the following manner. EG: abc_071128_144121_data "...

Login or Register to Ask a Question