Firstly thank you for the forum members I need to find time difference b'w two rows of timestamp using awk/shell.
Here is the logfile:
===========
The above logfile is kind of api file, and there are some rows start with "start" and "end",and the corresponding row's column 3rd to end of the row is timestamp (take delimiter as ":" ) we have to find the time difference between start and end time consecutive rows
Hope I am clear with the question,please let me know if you need more explanation.
Thx Srinivas
Last edited by Don Cragun; 02-22-2015 at 09:57 PM..
Reason: Add CODE tags.
Are we to assume that by consecutive rows, you mean a row starting with start and the next row starting with end ignoring all of the lines between them that do not start with start or end? Or are the only lines to be considered from your input file:
since these are the only consecutive lines that start with start and end?
And, based on the data you've shown us, can we assume that all time stamps to be compared occur on the same date and the last three fields on the start and end lines are hours, minutes, and seconds from a 12-hour clock with no indication of AM/PM? Or, do some of your samples end before they start?
With the sample input you provided, what output are you hoping to get?
I don't know how you get 6909 seconds (1 hour, 55 minutes, 9 seconds) difference for the second time difference for your sample input (11:46:34 - 11:00:45), but the following brute force awk script seems to perform the desired calculations:
If business_file contains:
it produces the output:
if you invoke that script with no arguments, and adds debugging information as follows:
if invoked with one or more arguments.
This was written and tested using the Korn shell, but it will work just as well with any shell that use basic Bourne shell syntax (such as ash, bash, dash, ksh, and sh).
This script will happily ignore any lines in your input file that do not start with "start:" or "end:", so you don't need to filter your input with grep.
If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk.
Hello,
In HP-UX how to find the date time difference ?
Start time: 28-APR-2019 21:36:01
End time : 29-APR-2019 00:36:04
----------------------
Difference is
----------------------
Much appreciate any pointer or view on this.
... (3 Replies)
Hello Expert,
I need to transpose Date-Timestamp based on same column values and calculate time difference. The input file would be as below and required output is mentioned in the bottom
INPUT File
========
08/23/2012 12:36:09 JOB_5340
08/23/2012 12:36:14 JOB_5340
08/23/2012... (2 Replies)
I have a file wich contains time formats and i need to get the time difference
TIME1 TIME2
=============== ===================
20120624192555.6Z 20120624204006.5Z
which means first date 2012/6/24 19:25:55,second date 2012/6/24 20:40:06 so when i get the time... (23 Replies)
I have a file wich contains time formats and i need to get the time difference
TIME1 TIME2
==================================
20120624192555.6Z 20120624204006.5Z
which means first date 2012/6/24 19:25:55,second date 2012/6/24 20:40:06 so when i get the time... (1 Reply)
Hello
I have a file in following format:
IV 08:09:07
NM 08:12:01
IC 08:12:00
MN 08:14:20
NM 08:14:15
I need a script to compare time on each line with previous line and show the inconsecutive line. Ex.:
08:12:00
08:14:15
A better way... (6 Replies)
Hi,
START_TIME :- "10-NOV-2009 00:00:04"
STOP_TIME :- "10-NOV-2009 00:05:47"
Please help to find difference between these two.
Searched for the same topic but did not find an answer for the same time format :(
Regards,
Robin (3 Replies)
HI All,
can some one please help me how to fine the difference between two time stamps say
a= Nov 10, 2009 9:21:25 AM
b= Nov 10, 2009 10:21:25 AM
I want to find difference between the a & b
I googled and tried with some options but no luck.
My OS is AIX (1 Reply)
Hi guru's,
Am new to shell scripting.
I am getting the below o/p from the oracle database, when I fire a query.
ID JOB_ID ELAPSED_TIME FROM TO
----- ------ ------------------- -------- --------
62663 11773 01/06/2009 09:49:13 SA CM
62664 11773 ... (4 Replies)
Hello Friends,
I want to write a script for the following:
nlscux62:tibprod> grep "2008 Apr 30 01:" SA_EHV_SPEED_SFC_IN_03-SA_EHV_SPEED_SFC_IN_03-2.log | grep -i post | more
2008 Apr 30 01:01:23:928 GMT +2 SAPAdapter.SA_EHV_SPEED_SFC_IN_03-SA_EHV_SPEED_SFC_IN_03-2 Info AER3-000095 IDOC... (2 Replies)