topic Re: awk help in Operating System - HP-UX

awk help

Jose Mosquera — Tue, 10 Sep 2002 13:00:54 GMT

I have the following trouble with awk command inside of a script file, I'm trying to insert $COUNTRY variable inside of print statement. $COUNTRY always be a numeric value.

cat access.idx|grep ^"2.$COUNTRY."|awk -F"." '{ print $3 }'|sort|uniq -c|awk '{ print "2."$COUNTRY"."$2".*\t"$1 }'

the following error output is displayed:
awk: Field $() is not correct.
The input line number is 1.
The source line number is 1.

I'm trying with "awk -v" argument, but I can not achieve a successfully result.

Re: awk help

Jose Mosquera — Tue, 10 Sep 2002 13:15:25 GMT

Hi Pals,

I have resolved this by:
cat access.idx|grep ^"2.$COUNTRY."|awk -F"." '{ print $3 }'|sort|uniq -c|awk -v CO=$COUNTRY '{ print "2."CO"."$2".*\t"$1 }'

Thanks anyway

Re: awk help

H.Merijn Brand (procura — Tue, 10 Sep 2002 13:17:45 GMT

Something like this?

# perl -ne's/^2\.$ENV{COUNTRY}\.// and print' access.idx | sort -u | sed "s/^/2.$COUNTRY/'

Re: awk help

Tom Danzig — Tue, 10 Sep 2002 13:31:25 GMT

You could do:

cat access.idx|grep ^"2.$COUNTRY."|awk -F"." '{ print $3 }'|sort|uniq -c|awk x=$COUNTRY '{print "2."x"."$2".*\t"$1 }'

Re: awk help

H.Merijn Brand (procura — Tue, 10 Sep 2002 13:32:11 GMT

Your problem was in the quote style you use:

awk '{ print "2."$COUNTRY"."$2".*\t"$1 }'

uses single quotes around the scriplet, causing $COUNTRY not to be evaluated as value, but as literal '$COUNTRY', something very unlikely to appear in your access.idx :)

awk '{ print "2."'$COUNTRY'"."$2".*\t"$1 }'

would have done the job to (see the single quotes around $COUNTRY)

Re: awk help

harry d brown jr — Tue, 10 Sep 2002 13:35:09 GMT

Change your last awk statement to this:

'{hello=system("echo $COUNTRY"); printf("2. %s.%s.%s",hello,$2,$1); }'

live free or die
harry