10-31-2010
Calculate difference between two successive values
Hi,
I have a file containing timestamps (at micro-seconds granularity). It looks like the following:
06:49:42.383818
06:49:42.390190
06:49:42.392308
06:49:42.392712
06:49:42.393437
06:49:42.393960
06:49:42.402115
Now I need a sed/awk script to take the difference of two successive time values i.e 2nd value - 1st value, 3rd value - 2nd value , 4th - 3rd and so on....and print them in a file.
So if the input file contains 7 entries, the output file should have 6 entries.
Since the input file is quite big (large number of entries), I need sed/awk script to process it quickly.
Any help will be highly appreciated.
Thanks !
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I've written a script which reads all the systems backup information and saves it in a log file.
ssh -l ora${sid} ${primaryhost} "tail -2 /oracle/$ORACLE_SID/sapbackup/back$ORACLE_SID.log" |head -1 | awk '{print echo "PREVIOUS:-- Start Date&Time: " $3,$4,echo "|| End Date&Time:... (1 Reply)
Discussion started by: suri.tyson
1 Replies
2. Shell Programming and Scripting
Hi All,
I've written a script which reads all the systems backup information and saves it in a log file.
ssh -l ora${sid} ${primaryhost} "tail -1 /oracle/$ORACLE_SID/sapbackup/back$ORACLE_SID.log" | awk '{print $3,$4,$5,$6}' >> ${RESULTFILE}
The output comes as below:
2008-09-30 06.00.01... (2 Replies)
Discussion started by: suri.tyson
2 Replies
3. Shell Programming and Scripting
Hello,
I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes...
I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes.
To do... (10 Replies)
Discussion started by: worm
10 Replies
4. Shell Programming and Scripting
Hi,
I have a file in the following format
a1 b1 c1 d1
a2 b2 c2 d2
a3 b3 c3 d3
a4 b4 c4 d4
I need a script to find the difference between corresponding values of successive rows. So the output would have one less row than the input file and should look like:
a2-a1 b2-b1 c2-c1 d2-d1... (4 Replies)
Discussion started by: sajal.bhatia
4 Replies
5. Shell Programming and Scripting
Hi,
I have a large log file in the following format.
Epoch-Time Bytes
899726401 20
899726401 30
899726402 40
899726402 10
899726402 50
899726403 50
899726403 ... (8 Replies)
Discussion started by: sajal.bhatia
8 Replies
6. Shell Programming and Scripting
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)
Discussion started by: asnandhakumar
2 Replies
7. Shell Programming and Scripting
Experts,
file1 : Want to find the difference of $3 field from next line's 3rd field,
The difference to be calculated from next lines 3rd field, to current lines lines 3rd field.
file1 :
Jun24_2013.06242013 3301244928 3133059904 167370640 95%
Jun25_1124.06252013 3301244928... (4 Replies)
Discussion started by: rveri
4 Replies
8. Shell Programming and Scripting
Hi All
Can you please help me with UNIX script code that will work with ksh shell on UNIX server
My Requirement
Time1: 09/17/13101536
Time2: 09/16/13101536
I want to calculate the difference in minutes for the dates with format given above. I have a requirement to wait for... (5 Replies)
Discussion started by: jimmyb
5 Replies
9. Shell Programming and Scripting
I have time in a file in HH:MM:SS format as it contents(its not the file creation time). i need this to be converted to epoch time or time since 1970. The time is written into that file by a script, which i cannot modify. Im using AIX machine
$ cat abc.txt
10:29:34 (2 Replies)
Discussion started by: gpk_newbie
2 Replies
10. Shell Programming and Scripting
In the awk I am trying to subtract the difference $3-$2 of each matching $4 before the first _ (underscore) and print that value in $13.
I think the awk will do that, but added comments. What I am not sure off is how to add a line or lines that will add sum each matching $13 value and put it in... (2 Replies)
Discussion started by: cmccabe
2 Replies
LEARN ABOUT DEBIAN
cd-hit-2d-para
CD-HIT-2D-PARA.PL(1) User Commands CD-HIT-2D-PARA.PL(1)
NAME
cd-hit-2d-para.pl - divide a big clustering job into pieces to run cd-hit-2d or cd-hit-est-2d jobs
SYNOPSIS
cd-hit-2d-para.pl options
DESCRIPTION
This script divide a big clustering job into pieces and submit jobs to remote computers over a network to make it parallel. After
all the jobs finished, the script merge the clustering results as if you just run a single cd-hit-2d or cd-hit-est-2d.
You can also use it to divide big jobs on a single computer if your computer does not have enough RAM (with -L option).
Requirements:
1 When run this script over a network, the directory where you
run the scripts and the input files must be available on all the remote hosts with identical path.
2 If you choose "ssh" to submit jobs, you have to have
passwordless ssh to any remote host, see ssh manual to know how to set up passwordless ssh.
3 I suggest to use queuing system instead of ssh,
I currently support PBS and SGE
4 cd-hit-2d cd-hit-est-2d cd-hit-div cd-hit-div.pl must be
in same directory where this script is in.
Options
-i input filename for 1st db in fasta format, required
-i2 input filename for 2nd db in fasta format, required
-o output filename, required
--P program, "cd-hit-2d" or "cd-hit-est-2d", default "cd-hit-2d"
--B filename of list of hosts, requred unless -Q or -L option is supplied
--L number of cpus on local computer, default 0 when you are not running it over a cluster, you can use this option to divide a big
clustering jobs into small pieces, I suggest you just use "--L 1" unless you have enough RAM for each cpu
--S Number of segments to split 1st db into, default 2
--S2 Number of segments to split 2nd db into, default 8
--Q number of jobs to submit to queue queuing system, default 0 by default, the program use ssh mode to submit remote jobs
--T type of queuing system, "PBS", "SGE" are supported, default PBS
--R restart file, used after a crash of run
-h print this help
More cd-hit-2d/cd-hit-est-2d options can be speicified in command line
Questions, bugs, contact Weizhong Li at liwz@sdsc.edu
cd-hit-2d-para.pl 4.6-2012-04-25 April 2012 CD-HIT-2D-PARA.PL(1)