How to sort a file -

[Bill Davidsen]

Bob Goodwin wrote:
> 
> I have a file of Netgear router data that I would like to sort on date 
> and time.
> the form is as below:
> 
>    [Site allowed: weather.noaa.gov] from source 192.168.1.9 Saturday,
>    Aug 01,2009 17:02:51
>    [Site allowed: safebrowsing-cache.google.com] from source
>    192.168.1.11 Saturday, Aug 01,2009 17:00:16
>    [Site allowed: safebrowsing.clients.google.com] from source
>    192.168.1.11 Saturday, Aug 01,2009 17:00:13
> 
> 
> The router appears to accumulate data until full and then clears at some 
> point and starts a new block of data.
> I can collect the data periodically [perhaps at 30 minute intervals, 
> whatever works for me] and append it to a new file I called 
> "home/bobg/NG-LOG" but this leaves me with a jumble of date/time 
> information since the raw log data is in descending order of date/time 
> and I am adding the latest data in the same order but at the bottom so 
> the list it may show 16:00-15:30 followed by the latest block on the 
> list 16:30-16:00.
> 
> I need to either sort the data as a function of time or append the new 
> data to the beginning of the "NG-LOG" file instead of the  end. I don't 
> know where to start on this? I'm probably missing something obvious but ...
> 
> Any suggestions appreciated.
> 
Looks like a case for a few lines of perl, and a quick call to sort for the 
ordering, probably the easiest fix.

See attached if the mailer doesn't eat it.

-- 
Bill Davidsen <davidsen at tmr.com>
   "We have more to fear from the bungling of the incompetent than from
the machinations of the wicked."  - from Slashdot
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logsort.pl
Type: application/x-perl
Size: 847 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20090803/1762f270/attachment-0001.pl>