Re: How to sort a file -

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxx>
  "We have more to fear from the bungling of the incompetent than from
the machinations of the wicked."  - from Slashdot

Attachment: logsort.pl
Description: Perl program

-- 
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines

[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux