Shell Programming and Scripting

Would you please help me on formatting the following lines of information.

Input file:
-- appl = host = user = / pid = 76 elapsed = 0.000 seconds server_elapsed = 0.000 [ one line only]
select emp_no, dept_no
from emp
where empname like 'Rob%'
;

-- appl = host = user = / pid = 76 elapsed = 0.000 seconds server_elapsed = 0.999 [ one line only]
select emp_no, dept_no
from dept
where deptname like 'IT%'
;

Output need to have all lines where server_elapsed >0.100 like below
server_elapsed=0.999 |select emp_no, dept_no from dept where deptname like 'IT%' ; [One line only]

Code:

>cat inp

-- appl = host = user = / pid = 76 elapsed = 0.000 seconds server_elapsed = 0.000
select emp_no, dept_no
from emp
where empname like 'Rob%'
;

-- appl = host = user = / pid = 76 elapsed = 0.000 seconds server_elapsed = 0.999
select emp_no, dept_no
from dept
where deptname like 'IT%'
;

Code:

firststring=`awk -F"=" '/server_elapsed/ { if( $7 > 0.100 ) { print "server_elapsed="$7"|"} }' inp`
val=`awk -F"=" '/server_elapsed/ { if( $7 > 0.100 ) { print NR } }' inp`
echo $firststring`awk -F"=" '{ if(NR > '$val' && NR <= '$val' + 4) { printf $0" " } }' inp`

output

Code:

server_elapsed= 0.999 |select emp_no, dept_no from dept where deptname like 'IT%' ;

Thanks for your help madhan. It is working fine. But I found some lines with more feilds in the first line and $7 is not validating.

For this I modified the code to
firststring=`awk -F"server_elapsed = " '/server_elapsed/ { if( $2 > 0.100 ) { print "server_elapsed="$2"|"} }' tran.log`
and the above line is working fine.

But the issue with number lines in the select statement they are not constant i.e 4.

I am getting with more like 1 ....50.

Would u please suggest me how to deal with this.

Thanks for your kind reply.

Thanks for your help on printing the input text matrixmadhan.

But I need help on multiple lines if they condition met.

-- appl = host = user = / pid = 76 elapsed = 0.000 seconds server_elapsed = 2.999
select emp_no, dept_no
from emp
where empname like 'Rob%'
;

-- appl = host = user = / pid = 76 elapsed = 0.000 seconds server_elapsed = 0.999
select emp_no, dept_no
from dept
where deptname like 'IT%'
;


As per the above input, there will be two output lines.

server_elapsed= 0.999 |select emp_no, dept_no from dept where deptname like 'IT%' ;
server_elapsed= 2.999 |select emp_no, dept_no from emp where empname like 'Rob%';

Would you please help me in printing.

I appreciate your kind reply.

Rgds,
AWK New Learner

you gave the input and output...

i am not clear with the requirement you request ..

could you please clarify ?

(i dont have good grasping skills)

here it is,
i should have thought earlier

Code:

#! /usr/bin/ksh

firststring=`awk -F"=" '/server_elapsed/ { if( $7 > 0.100 ) { print   server_elapsed="$7"|"} }' inp`
val=`awk -F"=" '/server_elapsed/ { if( $7 > 0.100 ) { print NR } }' inp`
echo $firststring`awk -F"=" 'BEGIN{} { if(NR > '$val' && $0 !~ /^;/ ) { printf $0" " } } END{ printf ";" }' inp`

exit 0

Thanks for your help matrix.

I am getting the following error, would you please help me on this.

Syntax Error The source line is 1.
The error context is
BEGIN{} { if(NR > >>> 1 <<<
awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.
awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.
awk: 0602-540 There is a missing } character.
awk: 0602-540 There is a missing ) character.