Shell Programming and Scripting

Hi, was hoping someone may be able to help me with a script solution to move one line to another line from my log file:

My log file currently looks like this:
01:21:12:383 Request
01:21:12:639 Response
01:21:12:386 Request
01:21:12:639 Response
01:21:12:389 Request
01:21:12:640 Response
01:21:12:610 Request
01:21:12:646 Response
01:21:12:645 Request
01:21:12:673 Response

I want it to look like this:
01:21:12:383 Request 01:21:12:639 Response
01:21:12:386 Request 01:21:12:639 Response
01:21:12:389 Request 01:21:12:640 Response
01:21:12:610 Request 01:21:12:646 Response
01:21:12:645 Request 01:21:12:673 Response

I'm thinking sed would probably be best for this but so far I cannot seem to get it to work

Any advice would be most welcome..

Cheers, Jim

Try...

Code:

paste -s -d ' \n' file1

thanks ygor - a nice easy one for you

much appreciated.

Code:

sed -n 'N;s/\n/ /p' file > newfile

i'm still a bit of a novice here and assumed I would be able to figure this out for myself but could do with some more advice please...

now I have my log file in this format:

01:11:15:423 Request 01:11:15:541 Response
01:11:15:424 Request 01:11:15:514 Response
01:11:15:436 Request 01:11:15:678 Response
01:11:15:516 Request 01:11:15:675 Response

I would like to calculate the total response time in ms by subtracting $1 from $3 and print the result in a new field at the end of each row:

01:11:15:423 Request 01:11:15:541 Response 118

I thought I might be able accomplish this with some sort of awk script but things seem to get complicated (for me) when dealing with the time stamp.

If anyone could advise the best way forward for this I'd really appreciate it.

Jim

just one of the many ways, you can do hard maths...:

Code:

awk '
	{
		n=split($1,one,":")
		hh=one[1]
		mm=one[2]
		ss=one[3]
		ms=one[4] #i assume its milleseconds?
		m=split($3,three,":")
		....
		...
		#do time maths..convert everything to seconds, 
		result =  result_of_three(secs) - result_of_one(secs)
                
	}
	{ print $0 " " result }
' "file"

nawk -f jim.awk myFile.txt

jim.awk:

Code:

BEGIN {
  SEPtime=":"
  multN=split("3600000:60000:1000:1", multA, SEPtime)
}

function t2milsec(time,   tempA, tempN, i, milsec)
{

  tempN=split(time, tempA, SEPtime)
  for(i=1; i<=tempN; i++)
    milsec += (tempA[i] * multA[i])
  return milsec
}

{ print $0, t2milsec($3) - t2milsec($1) }