Shell Programming and Scripting

hi,

I have a log file which contains data for last 7 seven days.
I want to copy all the data for 6 days in one file and keep only the data for today in that log file and mail that log file containing today's data.

Log file is in this format

Code:

 Time: 120529 10:51:08
 User@Host: local @  [3.210.45.78]  Id: 125684
 Query_time: 0.010631  Lock_time: 0.000044 Rows_sent: 2  Rows_examined: 11
SET timestamp=0000000;

 Time: 120530  5:01:35
 User@Host: local@  [3.247.587.21]  Id: 129386
 Query_time: 63.552782  Lock_time: 0.000051 Rows_sent: 5  Rows_examined: 9
SET timestamp=000000;

please suggest how to separate the entries.

---------- Post updated at 03:01 PM ---------- Previous update was at 02:37 PM ----------

Getting no idea how to do this

suggest some ideas.

Moderator's Comments:

edit by bakunin: please notice, that bumping up questions is against our rules. Furthermore, you posted roughly 30 minutes ago AND ALREADY GET IMPATIENT?? This is not a helpdesk and we are not your employees! There is no obligation for anyone here to answer a certain thread - much less to answer it within some time - and if you don't change your attitude the only thing you might get is some stony silence.

You might probably be interested in this thread where i discussed a very similar problem.

I hope this helps.

bakunin

I want the fragmentation on the basis of timestamp.i.e. data for today will be there and rest copied to some other file. also all the data for that timestamp should come.

Code:

Time: 120524 14:06:06
# User@Host:  @  [5.85.46.21]  Id: 11111111
# Query_time: 0.000564  Lock_time: 0.000056 Rows_sent: 0  Rows_examined: 2
SET timestamp=00000000;

like if it today's date matches with 120524 then all the lines below it should come.i.e user@host, id, query_time lock_time,rows_sent,rows_examined,set timestamp

Moderator's Comments:

edit by bakunin: please use [CODE]..[/CODE]-tags to enclose terminal output and code. It makes the text better readable.

There is no "timestamp" within a file. Using purely system means it is not possible to decide when a certain entry in a file has been written.

Of course it is possible to have some data in the file which you can interpret as timestamp, like, say, a line "date: 01/01/2000" and you will know that everything following this was later and everything before was earlier. But still you will have to search for that certain pattern, not for a "timestamp", like the "mtime" information of a files last modification time, which is built into the data structure of Unix filesystems.

So take the script part i provided in the mentioned thread, modify it to meet your needs and use it.

I hope this helps.

bakunin

Is this what your needs serve for todays match? If YES, then answer and I try to make the last six days match possible.

Code:

awk 'BEGIN{today=strftime("%y%m%d")} ($2 ~ today),/timestamp/' infile >today_to_email.log