Solved

to sort log files by date

Posted on 2008-10-25
8
585 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
  • 4
  • 4
8 Comments
 
LVL 48

Assisted Solution

by:Tintin
Tintin earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 48

Expert Comment

by:Tintin
Comment Utility
What format will the date be entered as?  Is this on Solaris 10?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

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

Expert Comment

by:Tintin
Comment Utility
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
Comment Utility
I really wish we could but we are not allowed to install software.
0
 
LVL 48

Accepted Solution

by:
Tintin earned 500 total points
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now