Shell Programming and Scripting

[0-9][0-9]* matches number of any length.

Hi anbu, thanks alot!!!

If you want to test for a 4-digit number in awk , you can use the syntax [0-9]{4}

Jean-Pierre.

Hi All,

To extend further, I would need the awk script to perform the average calculation on all the rest of the counts except for the 1st count no matter whether 1st count belongs to Group1 or Group2. Can anybody help me to modify the below to work in the above manner?


awk '
$1 ~ "^[0-9][0-9]*$" && $NF == 0 { grp1=grp1+$(NF-1); tot1=tot1+1 }
$1 ~ "^[0-9][0-9]*c$" && $NF == 0 { grp2=grp2+$(NF-1); tot2=tot2+1 }
END {
if(tot1 != 0 ) printf("Group1\nAverage = %f \n",grp1/tot1)
if(tot2 != 0 ) printf("Group2c\nAverage = %f\n",grp2/tot2)
}' file
For example, the below calculation will ignore the number "2826". So for Group1, it will output "2830" instead of the average of "2828"
Input:

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

0002 x= 1 $---------------------------------..-.--.. 0
0002 tt= 137 171 423 1682 2830 0

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

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

Group1
average = 2830

Group2(with "c" appended)
average = 3804

try this

Code:

awk '
NR > 3 &&  $1 ~ "^[0-9][0-9]*$" && $2 ~ "tt="  { grp1=grp1+$(NF-1); tot1=tot1+1}
NR > 3 &&  $1 ~ "^[0-9][0-9]*c$" && $2 ~ "tt=" { grp2=grp2+$(NF-1); tot2=tot2+1}
END {
if(tot1 != 0 ) printf("Group1\nAverage = %f \n",grp1/tot1)
if(tot2 != 0 ) printf("Group2c\nAverage = %f\n",grp2/tot2)
}' file

Thanks anbu ! It works just fine !!

Hi,

If input were to be a mixture (with the number of rows of "x= 1" varying and having a max of 3 rows of "x= 1"), i would want to have the following expected output. Note that only "x= 1" will be grabbed. How can i amemd the code below to suit this criteria

Code:

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

Eg.

Input:

0001 dblz= 23 0 0 1 .
0001 ri_esd= 1824 1824 605 605 605 601.5 603 602
0001 x= 1 ----------------------------------..-.--..
0001 x= 1 ----------------------------------..-.--..
0001 tt= 137 171 423 1682 2826 0
0002c UUU= 3597 3345 2993 2683
0002c zzz= 24 0 0 1 .
0002c ri_esd= 577 577.5 577 573.5 576 574.5 576
0002c x= 1 -----.----------------------------..-.--..--------
0002c x= 1 -----.----------------------------..-.--..--------
0002c x= 1 -----.----------------------------..-.--..--------
0002c tt= 132 167 423 1670 2708 3842 0
0003 dblz= 25 0 0 1 .
0003 ri_esd= 566 566 566 562 564.5 563.5
0003 x= 28 ----------------------------------..-.--..--------
0003 tt= 130 165 421 1666 2795 0
0004c UUU= 7304 6726 5942 5248
0004c zzz= 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

Expected output:

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

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

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