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.
> 
> Bob
> 
> 
You may want to look at the sort command. If you set ',' as your
delimiter, and tell it to use the second field, it will only sort on
Aug 01,2009 17:00:13. I am not sure if the -M option will do the
trick for you or not.

Mikkel
-- 

  Do not meddle in the affairs of dragons,
for thou art crunchy and taste good with Ketchup!

Attachment: signature.asc
Description: OpenPGP digital signature

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