Shell Programming and Scripting

Hi All,

i have an input below.
As long as "x= 1" , i would want to capture 2 lines using sed or awk
for eg :
0001 x= 1 $---------------------------------..-.--..
0001 tt= 137 171 423 1682 2826 0

Pls help. Thanks in advance.
Note that the number of lines in each block do vary.
For eg:
Below is considered 1 block
0001 ECID= DD7VRGB 10 17 23 3 8
0001 dblz= 23 0 0 1 .
0001 ri_esd= 1824 1824 605 605 605 601.5 603 602
0001 x= 1 $---------------------------------..-.--..
0001 tt= 137 171 423 1682 2826 0

Input:
0001 ECID= DD7VRGB 10 17 23 3 8
0001 dblz= 23 0 0 1 .
0001 ri_esd= 1824 1824 605 605 605 601.5 603 602
0001 x= 1 $---------------------------------..-.--..
0001 tt= 137 171 423 1682 2826 0
0002c ECID= DD7VRGB 15 10 135 3 8
0002c shmooU= 3597 3345 2993 2683
0002c dblz= 24 0 0 1 .
0002c ri_esd= 577 577.5 577 573.5 576 574.5 576
0002c x= 1 $----.----------------------------..-.--..--------
0002c tt= 132 167 423 1670 2708 3842 0
0003 ECID= DD7VRGB 8 11 237 3 9
0003 dblz= 25 0 0 1 .
0003 ri_esd= 566 566 566 562 564.5 563.5
0003 x= 28 H---------------------------------..-.--..--------
0003 tt= 130 165 421 1666 2795 0
0004c ECID= DD7VRGB 10 21 206 2 9
0004c shmooU= 7304 6726 5942 5248
0004c dblz= 26 0 0 1 .
0004c ri_esd= 564 564 564 560 562.5 561.5 563
0004c x= 1 $----.----------------------------..-.--..--------
0004c tt= 134 169 424 1676 2714 3766 0

Desired Output:
0001 x= 1 $---------------------------------..-.--..
0001 tt= 137 171 423 1682 2826 0

0002c x= 1 $----.----------------------------..-.--..--------
0002c tt= 132 167 423 1670 2708 3842 0

0004c x= 1 $----.----------------------------..-.--..--------
0004c tt= 134 169 424 1676 2714 3766 0

friendly alternative in Python:

Code:

#!/usr/bin/python
data = open("input.txt").readlines()
for i in range(len(data)):
        if "x= 1" in data[i]:
                print data[i] , data[i+1]

output:

Code:

/home> python test.py
0001 x= 1 $---------------------------------..-.--..
0001 tt= 137 171 423 1682 2826 0

0002c x= 1 $----.----------------------------..-.--..--------
0002c tt= 132 167 423 1670 2708 3842 0

0004c x= 1 $----.----------------------------..-.--..--------
0004c tt= 134 169 424 1676 2714 3766 0

Try this:

Code:

awk '{if($0~"x= 1"){flag=1; print} else{ if(flag==1){ print $0"\n"}; flag=0}}' awtest

Another way using awk:

Code:

awk '$0 ~ /^.*x= 1.*/{ print; getline; print $0"\n" }' awtest

Using sed:

Code:

sed -n '/^.*x= 1.*/{N;G;p;}' awtest

Hi Vish,

It works!!! Can you pls explain your code to me in detail because i don;t seem to understand it. Thanks

Hi shereenmotor,

Your codes are cool. It works fine. Can you explain both code in detail because i'm only a beginner. Thanks

Hi All,

To extend it, i would like to capture the highlighted numbers from the output here, such that i can calculate an average.
For example, for the 1st block 0001, i would like to capture 2826.
For example, for the 2nd and 3rd block 0002c and 0004c, it will output the average of 3842 and 3766. So at the end of it all, there will be 2 average numbers. One from block 0001 and one from block 0002c & 0004c. Note that those block numbers appended with "c" eg 0003c are seperated into a group to calculate the average. So there will be a 2 groups with 2 averages. Also note that the highlighted numbers will always have a "0" as the next field. However the number of field that the highlighted number is in may vary.

Input:

0001 x= 1 $---------------------------------..-.--..
0001 tt= 137 171 423 1682 2826 0

0002c x= 1 $----.----------------------------..-.--..--------
0002c tt= 132 167 423 1670 2708 3842 0

0004c x= 1 $----.----------------------------..-.--..--------
0004c tt= 134 169 424 1676 2714 3766 0

Desired output:

Group1
average = 2826

Group2(with "c" appended)
average = 3804