topic Re: How can i order a file by date .. in Operating System - HP-UX

How can i order a file by date ..

Manuales — Mon, 11 Mar 2013 06:04:40 GMT

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

Re: How can i order a file by date ..

Robert-Jan Goossens — Mon, 22 Feb 2010 21:01:53 GMT

Hi,

# ls -lr

Regards,
Robert-Jan

Re: How can i order a file by date ..

James R. Ferguson — Mon, 22 Feb 2010 21:09:25 GMT

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...

Re: How can i order a file by date ..

OldSchool — Mon, 22 Feb 2010 21:22:19 GMT

# 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

Re: How can i order a file by date ..

James R. Ferguson — Mon, 22 Feb 2010 21:30:05 GMT

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...

Re: How can i order a file by date ..

Tingli — Mon, 22 Feb 2010 21:34:02 GMT

Easiest way is:

ls -rlt

Re: How can i order a file by date ..

OldSchool — Tue, 23 Feb 2010 14:02:06 GMT

"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

Re: How can i order a file by date ..

Jupinder Bedi — Tue, 23 Feb 2010 14:16:47 GMT

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

and ls -lr

good luck

Re: How can i order a file by date ..

Steven Schweda — Tue, 23 Feb 2010 14:44:11 GMT

> 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?

Re: How can i order a file by date ..

James R. Ferguson — Tue, 23 Feb 2010 14:49:29 GMT

Hi:

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

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

...JRF...

Re: How can i order a file by date ..

Steven Schweda — Tue, 23 Feb 2010 15:42:00 GMT

> ...which adds what [...]

The authority of a Red-Star "Expert in this
area"?

It's a trend, apparently:

http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1409612

Could get annoying soon. (Oops. Too late.)

Do these Forum points have some cash value of
which I'm unaware?

Re: How can i order a file by date ..

Patrick Wallek — Tue, 23 Feb 2010 15:46:14 GMT

>>Do these Forum points have some cash value of
which I'm unaware?

Not anymore. In the past when you reached a particular level you would get some awards, gift certificates typically, but that was stopped in 2000 or 2001.

Re: How can i order a file by date ..

Steven Schweda — Tue, 23 Feb 2010 15:52:07 GMT

> [...] but that was stopped in 2000 or 2001.

Perhaps word hasn't gotten around. Sigh.