sum(col) finding from a file

Shell Programming and Scripting
1

Hi

I have an file which looks like

country address phone amount
sweden |address |phone | 10 |
Singapo |address |phone | 20 |
Italy-N |address |phone | 30 |
denmar |address |phone | 40 |

Here i need to do the sum(amount), how to do this in shell scripting

Thanks
Babu

2 
awk -F'|' 'NF>1 {sum+=$4} END {print sum}' inputfile

Jean-Pierre.

3

first line is not going to disturb the sum by anyway ..

the check NF>1 is not needed though

awk -F'|' ' {sum+=$4} END {print sum}' filename
4

Hi

I have an file it looks like

USSR|8650|262|Asia
Canada|3852|24|North America
China|3692|866|Asia
USA|3615|219|North America
Brazil|3286|116|South America
India|1269|637|Asia
Argentina|1072|26|South America
Sudan|968|19|Africa
Algeria|920|18|Africa

I have written a shell program which is not working. Pl help me where i am going wrong

FILE=/path/a.sh
area=0
total=0

for area in `grep a.sh | awk -F'|' '{print $2}'`
do
total=$(($total+$area))
done
echo $total

I tried with matrixmadhan and aigles, But it is not working.

Thanks
Babu

5

Your grep command is incomplete. Do you realy need this grep ?

FILE=/path/a.sh
area=0
total=0

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

or

FILE=/path/a.sh
total=0

total=$(awk -F'|' ' {sum+=$4} END {print sum}' $FILE)
echo $total

Jean-Pierre.

6

Thanks Jean It is working, I used grep becoz whether the file is found or not

Babu

7

USSR|8650|262|Asia
Canada|3852|24|North America
China|3692|866|Asia
USA|3615|219|North America
Brazil|3286|116|South America
India|1269|637|Asia
Argentina|1072|26|South America
Sudan|968|19|Africa
Algeria|920|18|Africa
***************

FILE=/path/a.sh
area=0
total=0

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

to my above shell scripts is working fine for one sum(column). How to use more than one col for sum ie $2 and $3 i want the sum

Thanks
Babu

8

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

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

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

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

10

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.)

 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.

11

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

12

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