Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to extract start/end times from log file to CSV file?
Top Forums Shell Programming and Scripting How to extract start/end times from log file to CSV file? Post 302926335 by derekludwig on Sunday 23rd of November 2014 01:08:35 PM
Old 11-23-2014
Modification of RudiC script (I unrolled the pipeline just to make it clearer to myself) that doesn't use the %(datefmt)T format of printf
Code:
awk '{print $3"-"$2"-"$1" "$4":"$5}' FS="[-: ]" "${1}" \
| date -f- +%s \
| {
  read oldT
  echo -n "${oldT} "
  N=1
  while read curT; do
    if [[ $(( curT - oldT )) -gt 60 ]]; then
      echo ${oldT} ${N}
      echo -n "${curT} "
      N=0
    fi
    oldT=${curT}
    (( N++ ))
  done
  echo ${oldT} ${N}
} \
| while read oldT newT N; do
  echo $(date +%d-%m-%Y\ %H:%M -d @${oldT}),$(date +%d-%m-%Y\ %H:%M -d @${newT}),${N}
done

See the manpage if your version of date doesn't support -d @seconds.
Testing with a larger dataset:
Code:
14-11-2014 05:23
14-11-2014 05:24
14-11-2014 05:25
14-11-2014 05:26
16-11-2014 13:01
16-11-2014 13:02
16-11-2014 13:03
23-11-2014 03:00
23-11-2014 05:24
23-11-2014 05:25
24-11-2014 08:24
24-11-2014 08:25
25-11-2014 08:58
25-11-2014 08:59
25-11-2014 09:00
25-11-2014 09:01
31-12-2014 23:47
31-12-2014 23:48
31-12-2014 23:49
    snip
01-01-2015 00:05
01-01-2015 00:06
01-01-2015 00:07

yielded:
Code:
14-11-2014 05:23,14-11-2014 05:26,4
16-11-2014 13:01,16-11-2014 13:03,3
23-11-2014 03:00,23-11-2014 03:00,1
23-11-2014 05:24,23-11-2014 05:25,2
24-11-2014 08:24,24-11-2014 08:25,2
25-11-2014 08:58,25-11-2014 09:01,4
31-12-2014 23:47,01-01-2015 00:07,21

(thanks to RudiC for giving me a starting point)
These 2 Users Gave Thanks to derekludwig For This Post:
Mr.Zizo RudiC
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Start and End times of background processes

Hi I'm running 4 jobs in the background and I need to write the start and end times to a log file. I know there's probably a simple way to do this but, I can't think of it. I've used nohup <script name> & but, that doesn't record the times. Is there a way to get the start and end times of a... (2 Replies)
Discussion started by: stonemonolith
2 Replies

2. Shell Programming and Scripting

extract a particular start and end pattern from a line

hi In the foll example the whole text in a single line.... i want to extract text from IPTel to RTCPBase.h. want to use this acrooss the whole file Updated: IPTel\platform\core\include\RTCPBase.h \main\MWS2051_Sablime_Int\1... (7 Replies)
Discussion started by: manish205
7 Replies

3. UNIX for Dummies Questions & Answers

Extract a specific number from an XML file based on the start and end tags

Hello People, I have the following contents in an XML file ........... ........... .......... ........... <Details = "Sample Details"> <Name>Bob</Name> <Age>34</Age> <Address>CA</Address> <ContactNumber>1234</ContactNumber> </Details> ........... ............. .............. (4 Replies)
Discussion started by: sushant172
4 Replies

4. Shell Programming and Scripting

can I specifiy the start and end times manually

Hi I have a ksh script which fetches data from a db using a number of .arc files and creates CSV files for them and puts them on the server. Question is, can I specifiy the start and stop times manually and run the script manually to fetch data for a certain period? # Get the current... (0 Replies)
Discussion started by: shajju
0 Replies

5. Shell Programming and Scripting

can I specifiy the start and end times manually

Hi I have a ksh script which fetches data from a db using a number of .arc files and creates CSV files for them and puts them on the server. Question is, how can I specifiy the start and stop times specifically so that data is fetched for a certain period? # Get the current time as the... (1 Reply)
Discussion started by: shajju
1 Replies

6. Shell Programming and Scripting

Extract data from an XML file & write into a CSV file

Hi All, I am having an XML tag like: <detail sim_ser_no_1="898407109001000090" imsi_1="452070001000090"> <security>ADM1=????</security> <security>PIN1=????</security> <security>PIN2=????</security> ... (2 Replies)
Discussion started by: ss_ss
2 Replies

7. Shell Programming and Scripting

Use grep sed or awk to extract string from log file and put into CSV

I'd like to copy strings from a log file and put them into a CSV. The strings could be on different line numbers, depending on size of log. Example Log File: File = foo.bat Date = 11/11/11 User = Foo Bar Size = 1024 ... CSV should look like: "foo.bat","11/11/11","Foo Bar","1024" (7 Replies)
Discussion started by: chipperuga
7 Replies

8. UNIX for Dummies Questions & Answers

extract regions of file based on start and end position

Hi, I have a file1 of many long sequences, each preceded by a unique header line. file2 is 3-columns list: headers name, start position, end position. I'd like to extract the sequence region of file1 specified in file2. Based on a post elsewhere, I found the code: awk... (2 Replies)
Discussion started by: pathunkathunk
2 Replies

9. Shell Programming and Scripting

Extract data from XML file and write in CSV file

Hi friend i have input as following XML file <?xml version="1.0"?> <Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.054.001.02"> <BkToCstmrDbtCdtNtfctn> <GrpHdr><MsgId>LBP-RDJ-TE000000-130042430010001001</MsgId><CreDtTm>2013-01-04T03:21:30</CreDtTm></GrpHdr>... (3 Replies)
Discussion started by: mohan sharma
3 Replies

10. Shell Programming and Scripting

Split a file by start and end row.

I have a file which looks something as following, I would like to split to several files, The start and end of each file is 'FILE' and end with 'ASCII... ' . At the same time for each file in the first column add 100 and also second column add 100 the rest of the column as it is , see example of... (2 Replies)
Discussion started by: tk2000
2 Replies

LEARN ABOUT FREEBSD

atf

ATF(7)						       BSD Miscellaneous Information Manual						    ATF(7)

NAME

     ATF -- introduction to the Automated Testing Framework

DESCRIPTION

     The Automated Testing Framework (ATF) is a collection of libraries to implement test programs in a variety of languages.  These libraries all
     offer similar functionality and any test program written with them exposes a consistent user interface.

     Test programs using the ATF libraries rely on a separate runtime engine to execute them in a deterministic fashion.  The runtime engine iso-
     lates the test programs from the rest of the system and ensures some common side-effects are cleaned up.  The runtime engine is also respon-
     sible for gathering the results of all tests and composing reports.  The current runtime of choice is Kyua, described in kyua(1).

     If your operating systems distributes ATF, it should also provide an introductory tests(7) manual page.  You are encouraged to read it now.

     The rest of this manual page serves as a cross-reference to all the other documentation shipped with ATF.

   Language bindings
     atf-c(3)		    C programming interface.

     atf-c++(3) 	    C++ programming interface.

     atf-sh(3)		    sh(1) programming interface.

   Miscellaneous pages
     atf-test-case(4)	    Generic description of test cases, independent of the language they are implemented in.

     atf-test-program(1)    Common interface provided by the test programs written using the ATF libraries.

SEE ALSO

     kyua(1), tests(7)

HISTORY

     ATF started as a Google Summer of Code 2007 project mentored by The NetBSD Foundation.  Its original goal was to provide a testing framework
     for the NetBSD operating system, but it grew as an independent project because the framework itself did not need to be tied to a specific
     operating system.

     Originally, ATF shipped the collection of libraries described in this manual page as well as a runtime engine.  The runtime engine has since
     been replaced by Kyua and the old tools were removed in 0.20, which shipped in early 2014.

     As of late 2014, both FreeBSD and NetBSD ship ATF in their base systems and provide extensive test suites based on it.

     For more details on historical changes, refer to:

	   /usr/share/doc/atf/NEWS

AUTHORS

     For more details on the people that made ATF possible, refer to:

	   /usr/share/doc/atf/AUTHORS

BSD
								September 14, 2014							       BSD
All times are GMT -4. The time now is 07:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy