Shell Programming and Scripting

Hi,

I am doing a time caclulation where i have output data with "Enter" & "Exit" time. I need to basically do a mathematical operation.

Following is the output file format

output.txt
==================

Code:

E,0:927629,Z,GUpdate
L,0:928079,Z,GUpdate
E,0:928419,Z,GUpdate
L,0:928865,Z,GUpdate
E,0:929201,Z,GUpdate
L,0:929646,Z,GUpdate

What to do:
------------
The line starting with "L" has exit time in 2rd column & line starting with "E" has "start" time in 2nd column after colon ":".

I need to get output fwith "leave time" minus(-) "start time" i.e subtraction.

This has to be done for every "enter" , "exit" pair in above file. eg. for first 2 lines execution time will be 928079-927629 = 530 and so on

Please guide.

You've been following this group for seven years. You have more than 180 posts.

What have you tried?

Hi,

Out of touch with unix since long time. I am able to do this in excel & obtaining the graph. So thought could try the same in UNIX as well. Can you guide?

You didn't say what system you're using.
You didn't say what shell you're using.
You didn't say what output format you want.
You might try something like:

Code:

awk -F '[,:]' '
$1 == "E" {
	e = $3
	next
}
$1 == "L" {
	print $3 - e
}' output.txt

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk.

With your sample input, it produces the output:

Code:

450
446
445