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]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux