Calculating sum


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Calculating sum
# 1  
Old 10-06-2013
Calculating sum

Hi all,

I have the following code in a shell script.

Code:
Code:
if [ "$3" == "gz" ]
        then
        echo "#[FILENAME_WITH_PATH]#"
        echo "#[ROW_COUNT]#"
        echo "##################################"

        for fn in `find "$1" -maxdepth 1 -iname \*"$2"* -type f`
                do

                echo "$fn"
                zcat $fn | wc -l
        #       pause 'Press [Enter] key to continue...'

                done
exit 0

which prints the following output:

Output:

Code:
#[FILENAME_WITH_PATH]#
#[ROW_COUNT]#
##################################
/data/EVDO_102_20130918132900.dat.gz
107108
/data/EVDO_102_20130918172800.dat.gz
127657
/data/EVDO_102_20130918163800.dat.gz
121060
/data/EVDO_102_20130918133000.dat.gz
111790
/data/EVDO_105_20130918133200.dat.gz
76544

The zcat command piped to 'wc -l' is producing the line count in each file in the specified directory.

I'm trying to print the sum of all the records in all the files. That is, 107108 + 127657 + 121060 + 111790 + 76544 = 544159.

Any inputs or thoughts on how I can achieve that would be greatly appreciated.

Thank you!
# 2  
Old 10-06-2013
Change:
Code:
                zcat $fn | wc -l
        #       pause 'Press [Enter] key to continue...'

                done
exit 0

to:
Code:
                cnt=$(zcat $fn | wc -l)
                printf "%12d\n" "$cnt"
                ((total += cnt))
        #       pause 'Press [Enter] key to continue...'

                done
        printf "============\n%12d\n" "$total"
exit 0

This User Gave Thanks to Don Cragun For This Post:
# 3  
Old 10-07-2013
Don,

Many thanks! That worked like a charm. And I have learnt some more. Thanks again.

-N.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Calculating average

Hi I have file like below 111,victor,48,12,36 342,Peter,54,58,30 476,Scott,25,36,48 567,Patty,74,17,95 I have written below code to calcualte avereage for every id Victor = 48+12+36/3 #!/bin/ksh /usr/xpg4/bin/awk ' BEGIN {FS=","} {sum=0; n=0;i=3 (1 Reply)
Discussion started by: stew
1 Replies

2. Shell Programming and Scripting

Calculating mean for samples 1-3 4-6 etc.

Hi. I have a LOOONG list of samples but I am not sure how to write the loop/script to calculate the mean... I normally use awk... ...................MEAN Sample1 25.82 40.61333 Sample1 47.6 Sample1 48.42 Sample2 54.03 54.12 Sample2 53.98 Sample2 54.35 etc..... I would like to... (4 Replies)
Discussion started by: danieladna
4 Replies

3. Shell Programming and Scripting

Calculating the epoch time from standard time using awk and calculating the duration

Hi All, I have the following time stamp data in 2 columns Date TimeStamp(also with milliseconds) 05/23/2012 08:30:11.250 05/23/2012 08:30:15.500 05/23/2012 08:31.15.500 . . etc From this data I need the following output. 0.00( row1-row1 in seconds) 04.25( row2-row1 in... (5 Replies)
Discussion started by: ks_reddy
5 Replies

4. Shell Programming and Scripting

Calculating using date

I need to help to calculating using date in a script. One application is licensed by date, some month at a time. I can read the date from system and get an output like this: echo $status 6A34 System4 01.01.11-31.01.11 My goal is to use license date 31.01.11 and subtract todays date... (7 Replies)
Discussion started by: Jotne
7 Replies

5. UNIX for Dummies Questions & Answers

Calculating average

Hi, i have 12 float variables in a bash file and i want to calculate the average of them. Can any body help? (6 Replies)
Discussion started by: limadario
6 Replies

6. Shell Programming and Scripting

Print sum and relative value of the sum

Hi i data looks like this: student 1 Subject1 45 55 Subject2 44 55 Subject3 33 44 // student 2 Subject1 45 55 Subject2 44 55 Subject3 33 44 i would like to sum $2, $3 (marks) and divide each entry in $2 and $3 with their respective sums and print for each student as $4 and... (2 Replies)
Discussion started by: saint2006
2 Replies

7. Shell Programming and Scripting

calculating in MB

hi all, have got a ksh script which tries to monitor memory usage of app servers. i do a ps -0 rss -p <PID> to get the memory size in KB but when i divide by 1024 to convert to MB i dont know how to round it up ?? thanks in advance. (3 Replies)
Discussion started by: cesarNZ
3 Replies

8. Shell Programming and Scripting

calculating a number

Hello all :) I need some help; I'm running the sp_spaceused command on various tables and saving the output to a file. So, I have an input file that has 3 rows - each row has 7 columns. I would like to 1) sort the file on the 4th column, 2) take the 4th column in the first row and add 25% to... (2 Replies)
Discussion started by: stonemonolith
2 Replies

9. Shell Programming and Scripting

calculating sum of fields in a file

Hey, I have a file and it has only one field. I need to calculate the sum of each filed as total. For e.g my file is 1 2 3 4 5 I need to calculate the total sum as 15. Please let me know how i can do it? (4 Replies)
Discussion started by: dsravan
4 Replies

10. Shell Programming and Scripting

Calculating the average

This is the cronjob ---------------------- root@a7germ:/home/paxtemp > crontab -l|grep test 57 * * * * /home/paxtemp/test_1.sh 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/paxtemp/test.sh root@a7germ:/home/paxtemp > This is the contents of test.sh script... (2 Replies)
Discussion started by: kekanap
2 Replies
Login or Register to Ask a Question