How can i order a file by date ..

[Manuales]

i have a file like this one (3500 rows apox):
user1 group1 Apr 12 2008 /home/user1.txt
user1 group3 May 18 2007 /home/user1.txt
user2 group5 Jan 23 2006 /home/user1.txt
user1 group1 Apr 12 2009 /home/user1.txt
user5 group6 Aug 17 2006 /home/user1.txt
user1 group3 Jul 16 2008 /home/user1.txt
user1 group8 Feb 15 14:13 /home/user1.txt
user5 group5 Jan 16 12:13 /home/user1.txt
user3 group1 Apr 15 2009 /home/user1.txt
user1 group8 Apr 13 2008 /home/user1.txt
......
......
......
......
......

i need to order these lines by date?
how can i do that?
do i have to make a program?
do you know something quick to do it?

thanks in advance.



P.S.This thread has been moved from HP-UX>System Administration to HP-UX > languages-HP Forums Moderator

[Robert-Jan Goossens · Accepted solution]

Hi,

# ls -lr

Regards,
Robert-Jan

[James R. Ferguson]

Hi:

If you didn't have mixed timestamp information with HH:MM and YYYY, then you could simply sort your file like this:

# sort -k5n,5 -kM3,3 -k4n,4 file

Since file timestamps that are within 6-months of the current date are reported with the HH:MM in place of the YYYY, you need to do something to manufacture the correct YYYY value as a sort key and/or generate a sort key that is an epoch seconds in the first place, and sort that.

Regards!

...JRF...

[OldSchool]

# sort -k5n,5 -kM3,3 -k4n,4 file

the month sort above appears to be incorrect. I believe it should read:

sort -k5n,5 -k3M,3 -k4n,4

[James R. Ferguson]

Hi (again):

> OldSchool: the month sort above appears to be incorrect. I believe it should read: sort -k5n,5 -k3M,3 -k4n,4

Yes, I transposed the "M". Thanks.

Regards!

...JRF...

[Tingli]

Easiest way is:

ls -rlt

[OldSchool]

"Easiest way is:

ls -rlt" -and-

"# ls -lr"

the problem is she's asking about the contents of a file, as indicated by ..."i have a file like this one (3500 rows apox)...:

given the existing contents, its pretty much a "sort" issue

[Jupinder Bedi]

sort -k5n,5 -k3M,3 -k4n,4


and ls -lr


good luck

[Steven Schweda]

> and ls -lr

Did that posting contribute anything (other
than repeating an error)?

> i need to order these lines by date?

Even if the desire were to sort an "ls"
report, how would "-lr" use the date?

[James R. Ferguson]

Hi:

> Jupinder: sort -k5n,5 -k3M,3 -k4n,4

...which adds what given that this is what I posted *yesterday*?

...JRF...