Solved

to sort log files by date

Posted on 2008-10-25
8
591 Views
Last Modified: 2013-12-27
Hi, I have logs files like this

<Oct 7, 2008 7:43:59 AM CDT> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
2008-10-07 07:44:14,106 INFO [org.springframework.core.CollectionFactory] - <JDK 1.4+ collections available>

I need to search all the lines for a particular date and then copy them to a different file. For example if I mention Oct 7, 2008 as input the above two lines are to be copied into a new file named  date_file.txt

Thanks in advance,
0
Comment
Question by:conversekid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 48

Assisted Solution

by:Tintin
Tintin earned 500 total points
ID: 22804998
Where does the sort come into the question?

To search for a date, you just need to do

egrep "2008-10-07|Oct 7, 2008" log >date_file.txt
0
 

Author Comment

by:conversekid
ID: 22805082
Thanks...I need to get the make it varaible..example we should be able to accept any date and then search for it......
0
 

Author Comment

by:conversekid
ID: 22805111
The date in the logs will be in either of the below two formats:
<Oct 7, 2008>
 2008-10-07
We need to search for these two formats depending on the date we get as input and then copy the lines containing these lines to a different file.....
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 48

Expert Comment

by:Tintin
ID: 22805450
What format will the date be entered as?  Is this on Solaris 10?
0
 

Author Comment

by:conversekid
ID: 22805635
Its solaris 9. We can ask the user to enter the date in any particular format.
0
 
LVL 48

Expert Comment

by:Tintin
ID: 22806328
One last question, are you allowed to install any additional software?  If you can install GNU date, it would make this task much more simple.
0
 

Author Comment

by:conversekid
ID: 22806422
I really wish we could but we are not allowed to install software.
0
 
LVL 48

Accepted Solution

by:
Tintin earned 500 total points
ID: 22806609
OK, here's a script which will accept input in YYYY-MM-DD format
#!/bin/sh
DATE1=$1
year=`echo $DATE1 | cut -f1 -d-`
mon=`echo $DATE1 | cut -f2 -d-`
day=`echo $DATE1 | cut -f3 -d- | sed "s/^0//"`
 
case $mon in
1)  mon=Jan ;;
2)  mon=Feb ;;
3)  mon=Mar ;;
4)  mon=Apr ;;
5)  mon=May ;;
6)  mon=Jun ;;
7)  mon=Jul ;;
8)  mon=Aug ;;
9)  mon=Sep ;;
10) mon=Oct ;;
11) mon=Nov ;;
12) mon=Dec ;;
esac
 
DATE2="$mon $day, $year"
egrep "$DATE1|$DATE2" /some/log >date_file.txt

Open in new window

0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Introduction Regular patching is part of a system administrator's tasks. However, many patches require that the system be in single-user mode before they can be installed. A cluster patch in particular can take quite a while to apply if the machine…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question