Solved

to sort log files by date

Posted on 2008-10-25
8
590 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

Industry Leaders: 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!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Parse DNS log 3 82
Unable to disassociate and associate elastic IP address EC2-VPC 6 53
bash while loop reading input from data section in script 7 71
batch file problem 5 75
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…
How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
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…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

740 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