Shell Programming and Scripting

Why don't you use awk all the way? It's quite capable of summing the columns, too.

Code:

awk -F '|' '{ area += $2; population += $3; }
END { print "area: " area; print "population: " population }' file

If you need to use the sums in subsequent processing then print them in some more machine-readble format. Maybe something like

Code:

set -- `awk '... whatever ... END { print area population }'`
echo area is $1
echo population is $2

I have an file a.sh which has

USSR|10|20|Asia
Canada|20|30|North America
China|30|40|Asia

I tried with era code, but is is giving wrong output

`awk -F '|' '{ area+=$2; total+=$3; }
END { print "area: " area; print "total: " total }'` /path/a.sh

awk: syntax error near line 1
awk: bailing out near line 1
/path/a.sh: USSR: not found
/path/a.sh: 10: not found
/path/a.sh: 20: not found
/path/a.sh: Asia: not found
/path/a.sh[2]: Canada: not found
/path/a.sh[2]: 30: not found
/path/a.sh[2]: 20: not found
/path/a.sh[2]: North: not found
/path/a.sh[3]: China: not found
/path/a.sh[3]: 40: not found
/path/a.sh[3]: 30: not found
/path/a.sh[3]: Asia: not found
echo $area
40
echo $total
150

It gave the following output. It is supposed to give the output as 60 and 90It has some error also. Pl help me

Thanks
Babu

You forgot the "set --" which needs to go before the backticks. It causes the positional parameters to be filled with the output from the command in the backticks. (So $1 is whatever awk echos in the first field, and $2 is the second field in the output, etc.)

Code:

 vnix$ awk -F '|' '{ area += $2; population += $3; }
> END { print "area: " area; print "population: " population }' <<HERE
> USSR|10|20|Asia
> Canada|20|30|North America
> China|30|40|Asia
> HERE
area: 60
population: 90
vnix$ 
vnix$ 
vnix$ set -- `awk -F '|' '{ area+=$2; total+=$3; }
END { print "area: " area; print "total: " total }' <<HERE
> USSR|10|20|Asia
> Canada|20|30|North America
> China|30|40|Asia
> HERE
> ` # <- note closing backtick here
vnix$ echo $1
area:
vnix$ echo $2
60
vnix$ echo $4
90

You need to use either one or the other, not mix the two variants I posted.

Hi

I have a FILE a.sh which has

USSR |10 |20 |Asia
Canada|20.4|30 |North America
China |30 |40.4|Asia

I have written a shell program follows

FILE=/path/a.sh
var=0
credit=0
var1=0
debit=0

for var in `awk -F'|' '{print $2}' $FILE`
do
credit=$(($credit+$var))
done
echo $credit

for var in `awk -F'|' '{print $3}' $FILE`
do
debit=$(($debit+$var1))
done
echo $debit

I am NOT getting the DECIMAL VALUES i am getting 60 AND 90 AS the output

But i want the output AS 60.40 AND 90.40. Need your gr8 help

Thanks
babu

shell arithmetic is integers only, use awk instead, you have a script already.