topic Re: SORTing a VMS file as per time stamp in Operating System - OpenVMS

SORTing a VMS file as per time stamp

Sk Noorul Hassan — Mon, 05 Feb 2007 05:47:39 GMT

Hi all,

Please guide me on how to sort the file as per time stamp in descending order. I am atttaching a sample file for this.

Re: SORTing a VMS file as per time stamp

labadie_1 — Mon, 05 Feb 2007 06:04:14 GMT

if your file is called a.tmp, something like

sort /key=(pos:39,siz=19) a.tmp b.tmp

You have the sorted file in b.tmp

$ Help sort

will give you more information.

Re: SORTing a VMS file as per time stamp

Robert Gezelter — Mon, 05 Feb 2007 06:15:42 GMT

Hassan,

After lookiing at your sample file, a straightforward observation: First correct the time/date format to yyyy-mm-dd:hh:mm:ss.

Changing the time information to the above format will allow the time/date information to be sorted as a single key. Then use a SORT command as Gerard stated in his post.

- Bob Gezelter, http://www.rlgsc.com

Re: SORTing a VMS file as per time stamp

Jan van den Ende — Mon, 05 Feb 2007 06:32:20 GMT

Slihgt correction on Gerard Labadie's answer.
Sin your date-stamp is NOT Year-month-day, you need to construct a multi-key SORT, for which you have to break-up your date-field.

As Gerard says:
$ HELP SORT
especially the /KEY paragraph is relevant here.

hth

Proost.

Have one on me.

jpe

Re: SORTing a VMS file as per time stamp

Hein van den Heuvel — Mon, 05 Feb 2007 07:46:10 GMT

That dd-mm-yyyy:hh:mm:cc is an easy time stamp!
Too bad it was not yyyy-mm-dd:.... even easier!

Anyway to get several ideas:
google: +openvms +directory +sort "by date"

And of course, check HELP SORT/KEY as suggesed.

A recent entry here with tricky, textual, months:

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

Actual solution is probably:

$ sort/key=(pos:46,size:4,des)/key=(pos:43,siz:2,des)/key=(pos:40,siz:2,des)/key=(pos:51,siz:8,des)

hth,
Hein

Re: SORTing a VMS file as per time stamp

Sk Noorul Hassan — Tue, 06 Feb 2007 08:11:55 GMT

Thanks for your help.