UNIX for Advanced & Expert Users

thanks murphy,

Could you please tell or clarify me one thing, is there any problem when we store the value in a variable using awk ?
as:

fpm=`awk '$2=="174" { print $3 }' tempfind.txt` | sed -n /$fpm/p tempfind.txt

and

fpm=`awk '$2=="966906" {print $3}' tempfind.txt` | echo "$fpm"


let me know.
thnks.
Varun.

AFAIK the problem lies in using single quotes in the second awk command. You are running a nested awk, so using single quotes again will confuse the initial outer awk script, (I ran into the same problem before).
So I'd suggest try to avoid the single quotes and use the other methods shown here to assign the variables.

Hope it helps.

Hey,

Could you please tell me, how to get a particular cell value using awk.
As far as I know, awk works on records.,

As :
--------------------------------------
mqsiaaa 123 888
mqsiddd 456 999
t2589gg 789 555
-------------------------------------

In the above table, say i search using $2 column and i want to get the value of $3 of that searched record.

awk '$2~/456/ { printf $3 > "filefilter"}' temp.txt

Means I want the 999 only corrosponding to the search, but as awk works on records and $3 represent whole third column, it used to give me
888
999
555
all the three values in filefilter., BUT i want only 999 (respective to the matched record and its 3rd cell value.)

How to achieve that ??
Do let me know.

Thanks in advance.
Varun.

Sure, but I was refering to the issues using single quotes in a nested awk. Back to your awk command, I see no issues using it as is. From the command line the output is correct:

Code:

cat temp.txt

mqsiaaa 123 888
mqsiddd 456 999
t2589gg 789 555

and

Code:

awk '$2~/456/ { printf $3 > "filefilter"}' temp.txt

   #The expected output is correct:

cat filefilter
999

Same can be said if you use a variable:

Code:

var=`awk '$2~/456/ { printf $3 }' temp.txt`
echo $var
999

---------------------------------------------------------
Thanks a lot man !!

Could you please check following way of writing awk is correct or not ???

-----------------------------------------------------------

pattern= "mqsi[admtspr]"

cat tempgrep.txt | \
while read ppid
do
awk '{
recurcive_fun(ppid, pattern)
function recurcive_fun(n, pattern)
{
awk '{ if ($2~n && $1~pattern){
n=$3
recurcive_fun(n, pattern)}
else{
if ($2~n && $1!~pettern){
print $1 >> "tempmail.txt"
exit
}
else {next}
}
}' tempfind.txt
}
}'

done
-----------------------------------------------------------------

Its recursion being called.

tempgrep.txt has :
462948
1311040
880922

tempfind.txt has :
t2589vg 880922 462948 09:57:07 -ksh
mqsiadm 1298856 1311040 09:57:56 -ksh
mqsiadm 1311040 880922 09:57:19 -ksh

Please suggust !!
Thanks
Varun