Hi ! all I am just trying to check range in my datafile
pls tell me why its resulting wrong
admin@IEEE:~/Desktop$ cat test.txt
0 28.4
5 28.4
10 28.4
15 28.5
20 28.5
25 28.6
30 28.6
35 28.7
40 28.7
45 28.7
50 28.8
55 28.8
60 28.8
65 28.1
70 26.5
This I tried
admin@IEEE:~/Desktop$ cat awk.sh
awk 'FNR==1{i++}{LC=NR}
{for(k=1; k<=NF; k++)A[i,FNR,k]=$k} #ARRAY
END{
j=1;
while(j<=LC[1]) # IF J<=Line Count do following
{
x=A[1,j,2]-A[1,1,2]
if(x>=0.1)break
print x,j,A[1,j,2],A[1,j,1]
j++
}}' OFS="\t" test.txt
Resulting
admin@IEEE:~/Desktop$ sh awk.sh
0 1 28.4 0
0 2 28.4 5
0 3 28.4 10
Here I actually require line No 4 record.