Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Grep question

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Grep question
# 1  
Old 11-19-2004
Grep question
I have a large log file. I want to keep 1 week worth of records. This is what part of file looks like:

Oct 04 09:16:59 [INFORMATION] Order intfc ended normally on 10/04/2004 at 09:16.
Oct 04 09:16:59 [INFORMATION] ------------------------------------------------
Oct 04 09:16:59 [INFORMATION] TM: Program <Iordload> ended (normal, exit <0>).

********

WARNING: The following errors occurred running sqlldr...

SQL*Loader: Release 9.2.0.5.0 - Production on Mon Oct 4 09:16:57 2004

Oct 04 09:32:04 [INFORMATION] Access code is valid.
Oct 04 09:32:04 [INFORMATION] Task master: Program <Iordload> started.
Oct 04 09:32:04 [WARNING] Ord <B394588-SFI>: cannot modify ord that does not exist. Ord will be added with <I> status.


Is there a way to truncate the records that are less than today's date - 7 days? I think it would be easier to do if each and every record began with a date, but in this file they don't. Any help would be greatly appreciated.
# 2  
Old 11-19-2004
What seems to me that you are trying to Load records
into a database using SQL Loader.
What am I not getting is that why are you truncating the log
to have records for a week?
Are you trying to spilt the log into data of 1 week?

Enc.
# 3  
Old 11-19-2004
On second thoughts!!

If you want lines in the log which have the date exactly 1 week from todays date
you can try:

code:
Quote:

#!/bin/bash
LAST_WEEK=`perl -e '$t=localtime(time-604800);print "$t\n"';`
SEARCH_STRING=`echo $LAST_WEEK|awk '{print $2,$3}'`
grep $SEARCH_STRING <path to your_log_file>
Hope That helps
enc.
# 4  
Old 11-19-2004
This log file gets auto generated by another system of ours. I was just trying to point out that in this file, not all of the lines have a timestamp associated with them. Maybe it would be easier and better if I could just figure out how to chop off the first X rows from the file.
# 5  
Old 11-19-2004
Once a night do something like...

mv file.6 file.7
mv file.5 file.6
mv file.4 file.5
mv file.3 file.4
mv file.2 file.3
cp file file.2
> file
# 6  
Old 11-19-2004
U can write the log file every day to a new different file based on date format ;


If u do n't have a control of this ......,

Is there any pattern of 'first line' it prints on every day ; Find out the line number using 'grep' ; Let's say that is 'm'

Try for the second day using grep ; Let's say the second day starts with line number 'n'

Seperate the first day logs using head and tail .... between

m and n-1 lines.




Repeast the same thing for other 6 days.

Hope this helps.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Grep Question

My grep returns a row of data like this: 75=20130130;60=074338;61=985;511=55473883;452=115439;62=196;267=1; Is there a way for the grep to only return 60="something" and 511="something" ? Thanks in advance. (10 Replies)
Discussion started by: Carl2013
10 Replies

2. UNIX for Dummies Questions & Answers

Question on grep

Hello all, I'm trying to grep the string "scott" from all files whose names are like srvr*.log and that were created "Nov 15"...I'm trying the following command but throws an error message...seems like the syntax is incorrect.. grep scott < ls -l srvr*.log|grep "Nov 15" Thanks for your... (9 Replies)
Discussion started by: luft
9 Replies

3. Shell Programming and Scripting

Question about grep

is there anyway i can ask grep to only get the first line? as in the top command line line 1 <-- just grep this line line 2 line 3 ---------- Post updated at 04:24 PM ---------- Previous update was at 04:19 PM ---------- nvm.. found out that i can do it with |head (12 Replies)
Discussion started by: Nick1097
12 Replies

4. Shell Programming and Scripting

Question about grep

can anyone tell me what the \/$ means? from grep \/$ (8 Replies)
Discussion started by: Nick1097
8 Replies

5. Shell Programming and Scripting

grep question please

i have files with "DOMAINSOLVER ACMS" with any number of spaces in between the two words on its own line and i can find it with the following: grep -c "DOMAINSOLVER* ACMS" $FILENAMEbut i need to exclude any lines matching: "$DOMAINSOLVER". i've tried a variety of quoting and escaping with no luck.... (4 Replies)
Discussion started by: crimso
4 Replies

6. Shell Programming and Scripting

grep question

Hello, Is there a way in grep to remember patterns? For eg: int a,b,c,d,a; If a variable is declared twice, like in the previous example, I should be able to print only those lines. Is there a way to print only the lines where the variable name occurs more than once, using grep... (1 Reply)
Discussion started by: prasanna1157
1 Replies

7. UNIX for Dummies Questions & Answers

grep question

Instead of using the following command #dmesg | grep -v sendmail | grep -v xntpd How can I use just one grep -v and give both arguments. Please suggest thanks (4 Replies)
Discussion started by: Tirmazi
4 Replies

8. Shell Programming and Scripting

grep question

hello people, All my servers have 4 mounts with this norme. For example, if my hostname is siroe. df -h | grep `hostname` /dev/dsk/c1t3d0s6 404G 399G 800M 100% /siroe3 /dev/dsk/c1t2d0s6 404G 399G 800M 100% /siroe2 /dev/md/dsk/d6 20G 812M 19G ... (3 Replies)
Discussion started by: melanie_pfefer
3 Replies

9. UNIX for Dummies Questions & Answers

Grep Question

Hello Everybody, I have files; yyyymmdd.log which the data look like this; "Txid=9426043&MsgTxt=Thankyou&UserId=john&Password=jh2501" "Txid=9426150&MsgTxt=Thankyou&UserId=john&Password=jh2501" . . . "Txid=9426200&MsgTxt=Thankyou&UserId=john&Password=jh2501" Question 1: How to... (3 Replies)
Discussion started by: nazri76
3 Replies

10. UNIX for Dummies Questions & Answers

grep question

what is the format for grep if I want to search from the current directory and through all its subdirectories?:) (3 Replies)
Discussion started by: pkappaz
3 Replies
Login or Register to Ask a Question