Shell Programming and Scripting

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

Code:

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

Jean-Pierre.

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

the check NF>1 is not needed though

Code:

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

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

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

Code:

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

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

or

Code:

FILE=/path/a.sh
total=0

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

Jean-Pierre.

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

Babu

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