problem in comparing awk field variable with stored value variable

lalith.145 · 01-15-2015, 08:00 PM

Hi,

My value is stored in a variable j in unix.I want to compare it with $1 of awk like awk '$1 = $j'.I need first column values that matches with the value in j.Please suggest.

Thanks
Lalith

danielbmartin · 01-15-2015, 08:19 PM

With this InFile ...

Code:

4 7 2 15 6 9 1
1 3 55 77 9
1 2 3 4 6 7 8 9
2     5 5 5 5 5 5

... this code ...

Code:

j=5
awk -v j=$j '{k=index($0,j);
  if (k>0) print "In line",NR,"the first",j,"was in position",k;
  else print "In line",NR,"there was no match on",j'} $InFile >$OutFile

... produced this OutFile ...

Code:

In line 1 the first 5 was in position 8
In line 2 the first 5 was in position 5
In line 3 there was no match on 5
In line 4 the first 5 was in position 7

Daniel B. Martin

danielbmartin · 01-15-2015, 08:46 PM

With this InFile ...

Code:

4 7 2 15 6 9 1
1 3 55 77 9
1 2 3 4 6 7 8 9
2     5 5 5 5 5 5

... this code ...

Code:

j=55
awk -v j=$j '{for (k=1;k<=NF;k++)
  if ($k==j) {print "In line",NR,"the first column which equalled",j,"was number",k; break}
  if (k>NF)  print "In line",NR,"there was no column which equalled",j'} $InFile >$OutFile

... produced this OutFile ...

Code:

In line 1 there was no column which equalled 55
In line 2 the first column which equalled 55 was number 3
In line 3 there was no column which equalled 55
In line 4 there was no column which equalled 55

Daniel B. Martin