need help with sorting a file

pieman8080 · #1 (**permalink**) 11-17-2006

I'm trying sort a log file (text file) from oldest to newest. Each line of the file has an output like:

service;username;release_number_number;environment;<date>;service-environment-<yyyyddmm>-<mm:ss>

the <date> format are like the following examples:
Fri Nov 17 06:33:13 PST 2006
Thu Nov 16 15:36:00 PST 2006

Here is an example of a real entry in my log file:
testapp;jhill;11_11-11;st;Tue May 30 12:35:00 PDT 2006;testapp-st-20060530-12:35

Ok so you get the idea.

Here's my issue. I have a log file similar to this on 2 different servers and I want to combine them.

I know i can cat one file and append to the other, but I want to them have in order as far as date. If I append 1 file to the other, what command could i use to sort? Spefically I'm trying to sort the <date> field above. Thanks

jim mcnamara · #2 (**permalink**) 11-17-2006

Can't you sort the last date field ie., 20060530-12:35

Code:

sort -t"-" -k2.1,2.8 -k3.1,3.5 inputlogfile

Just define the field sep as "-"

Edit - I just noticed a "-" early in the string. You may need another way to define fields.

futurelet · #3 (**permalink**) 11-18-2006

Code:

ruby -e 'puts ARGF.sort_by{|s| s.chomp[-14,14]}'  myfile

pieman8080 · #4 (**permalink**) 11-20-2006

I don't have ruby installed. Is there any way to do it using sort?

nilesrex · #5 (**permalink**) 11-21-2006

sort -t\; -k5,5 inputfile

pieman8080 · #6 (**permalink**) 11-21-2006

That's close. That sorted it by the time, so in the example below:

testapp;jhill;11_11-11;st;Tue May 30 12:35:00 PDT 2006;testapp-st-20060530-12:35

It sorted it by the "12:35:00" time. But I need it sorted by the day and time, or the "May 30 12:35:00" part. Is there a way to sort both? thx

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Sorting a file	mtechnocrat	UNIX for Dummies Questions & Answers	11	06-28-2007 07:28 AM
file sorting	phani_sree	Shell Programming and Scripting	5	02-05-2007 02:39 AM
Sorting a file	Khoomfire	Shell Programming and Scripting	2	12-13-2005 07:48 AM
sorting file	sx3v1l_1n51de	Shell Programming and Scripting	4	06-22-2005 01:16 PM
Help sorting file.	gio123bg	Shell Programming and Scripting	3	12-10-2003 10:15 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by