Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Separate a file on the basis of timestamp
Top Forums Shell Programming and Scripting Separate a file on the basis of timestamp Post 302648767 by sdf on Wednesday 30th of May 2012 10:29:27 AM
Old 05-30-2012
Quote:
Originally Posted by arijitsaha
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.
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

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sorting of files on the basis of timestamp

Hi, With the help of below script im able to get the count of all the .xml files but that count is not specific to a day ie its the total count of all .xml files what i want is specific to 1 day and that of every half an hr ie from 23 feb 2009 7 am till 23rd feb 2009 2300 am and from 07:00 to... (1 Reply)
Discussion started by: ss_ss
1 Replies

2. Shell Programming and Scripting

Separate date timestamp use awk or sed command ?

Hi, I have logfile like this : Actually the format is date format : yyyymmddHHMMSS and i want the log become this format yyyy-mm-dd HH:MM:SS for example 2009-07-19 11:46:52 Can somebody help me ? Thanks in advance (3 Replies)
Discussion started by: justbow
3 Replies

3. Shell Programming and Scripting

Split one file to Multiple file with report basis in unix

Hi, Please help on this. i want split the below file(11020111.CLT) to more files with some condition. :b: 1) %s stating of the report 2) %e ending of the report example starting of the report: %sAEGONCA| |MUMBAI | :EXPC|N|D ending of the report %eAEGONCA| |MUMBAI | :EXPC 3)so the... (10 Replies)
Discussion started by: krbala1985
10 Replies

4. Shell Programming and Scripting

Getting a relative timestamp from timestamp stored in a file

Hi, I've a file in the following format 1999-APR-8 17:31:06 1500 3 45 1999-APR-8 17:31:15 1500 3 45 1999-APR-8 17:31:25 1500 3 45 1999-APR-8 17:31:30 1500 3 45 1999-APR-8 17:31:55 1500 3 45 1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies

5. Shell Programming and Scripting

FTP a file on Hourly basis

Hi, I have to upload a file test_201105281100.txt to a ftp location. The files will be created on hourly basis like test_201105281100.txt, test_201105281200.txt & so on. After a file is uploaded successfully, I need to rename the file as test_201105281100.success & if it is not uploaded... (11 Replies)
Discussion started by: SunilB2011
11 Replies

6. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

7. UNIX for Dummies Questions & Answers

Splitting the file basis of Line Number

Can u pls advise the unix command as I have a file which contain the records in the below format 333434 435435 435443 434543 343536 Now the total line count is 89380 , now i want to create a separate I am trying to split my large big file into small bits using the line... (2 Replies)
Discussion started by: punpun66
2 Replies

8. Shell Programming and Scripting

Script to move file on a daily basis

Hi! Please I need help on the a script that would pick one file in a directory, change its name, them change its permissions, them move to a different directory, but has to be done on a daily basis, and the file that is being moved to its final destination has to have the following format:... (7 Replies)
Discussion started by: fretagi
7 Replies

9. Shell Programming and Scripting

Splitting XML file on basis of line number into multiple file

Hi All, I have more than half million lines of XML file , wanted to split in four files in a such a way that top 7 lines should be present in each file on top and bottom line of should be present in each file at bottom. from the 8th line actual record starts and each record contains 15 lines... (14 Replies)
Discussion started by: ajju
14 Replies

10. Shell Programming and Scripting

Looping through XML file on basis of a node

<?xml version="1.0" encoding="UTF-8"?> <Document> <FIToFICstmrCdtTrf> <GrpHdr> <MsgId>10001</MsgId> <NbOfTxs>1</NbOfTxs> <IntrBkSttlmDt>2015-05-06</IntrBkSttlmDt> <SttlmInf> <SttlmMtd>CLRG</SttlmMtd> </SttlmInf> <PmtTpInf> ... (2 Replies)
Discussion started by: harish2015
2 Replies

LEARN ABOUT DEBIAN

sqlgrey-logstats

sqlgrey-logstats(1)					User Contributed Perl Documentation				       sqlgrey-logstats(1)

NAME

       sqlgrey-logstats - SQLgrey log parser

SYNOPSIS

       sqlgrey-logstats [options...] < syslogfile

	-h, --help	       display this help and exit
	    --man	       display man page
	    --version	       output version information and exit
	    --debug	       output detailed log parsing steps

	-y, --yesterday        compute stats for yesterday
	-t, --today	       compute stats for today
	    --lasthour	       compute stats for last hour
	-d, --lastday	       compute stats for last 24 hours
	-w, --lastweek	       compute stats for last 7 days

	    --programname      program name looked into log file

	    --top-from	       how many from AWL entries to print (default: all)
	    --top-domain       how many domain AWL entries to print (default: all)
	    --top-spam	       how many SPAM sources to print (default: all)
	    --top-throttled    how many throttled sources to print (default: all)
	    --print-delayed    print delayed sources (default: don't)

DESCRIPTION

       sqlgrey-logstats ...

SEE ALSO

       See <http://www.greylisting.org/> for a description of what greylisting is and <http://www.postfix.org/SMTPD_POLICY_README.html> for a
       description of how Postfix policy servers work.

COPYRIGHT

       Copyright (c) 2004 by Lionel Bouton.

LICENSE

       This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
       Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

AUTHOR

       Lionel Bouton <lionel-dev@bouton.name>

perl v5.14.2							    2012-02-16						       sqlgrey-logstats(1)
All times are GMT -4. The time now is 06:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy