sum of all matching rows using awk Post: 302222235

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

bash script, pattern matching + sum

Hi guys, i have been struggling to achieve the following and therefor looking for some help. I am trying to write something that will summerize the following output from my switches for daily totals. Basicly if $1 $2 $3 doesnt change, we can keep adding up $4. Probably would use a awk print end...

2. Shell Programming and Scripting

Sum all rows with an Awk one-liner

I have a file with 1000+ columns of data. I need to sum each row (not column). How can I do this with an awk one-liner? Thank you Example file: 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 The output should be: 10 20 30

3. UNIX for Dummies Questions & Answers

how to count number of rows and sum of column using awk

Hi All, I have the following input which i want to process using AWK. Rows,NC,amount 1,1202,0.192387 2,1201,0.111111 3,1201,0.123456 i want the following output count of rows = 3 ,sum of amount = 0.426954 Many thanks

4. UNIX for Dummies Questions & Answers

Sum the rows number based on first field string value

Hi, I have a file like this one h1 4.70650E-04 4.70650E-04 4.70650E-04 h2 1.92912E-04 1.92912E-04 1.92912E-04 h3A 3.10160E-11 2.94562E-11 2.78458E-11 h4 0.00000E+00 0.00000E+00 0.00000E+00 h1 1.18164E-12 2.74150E-12 4.35187E-12 h1 7.60813E-01 7.60813E-01 7.60813E-01...

5. Shell Programming and Scripting

Sum of column matching pattern/string

Hi All, I have the following output file created as a result of one script called pattern_daily.log $ cat pattern_daily.log Approved|2|Wed, Oct 24, 2012 11:21:09 AM Declined|1|Wed, Oct 24, 2012 11:21:15 AM Approved|2|Wed, Oct 24, 2012 11:24:08 AM Declined|1|Wed, Oct 24, 2012 11:24:18 AM...

6. UNIX for Dummies Questions & Answers

List all files with sum of matching word

grep -c 'avihai' 1.log will give me count of 'avihai' in log I want to have a list of files in the folder that show file name with count side by side. Please advice

7. Shell Programming and Scripting

Sum of range of rows and columns in matrix

Hi all, I have a large matrix of 720 x 25. I want to get sum of range of rows and columns. Like, I need sum of all columns and row number 2 to 21, then leaving 22nd row, again sum of all columns and row number 23 to 42 again leaving 43rd row and then sum of 44th to 63. Means I want to add all...

8. Shell Programming and Scripting

awk split columns after matching on rows and summing the last column

input: chr1 1 2 3 chr1 1 2 4 chr1 2 4 5 chr2 3 6 9 chr2 3 6 10 Code: awk '{a+=$4}END{for (i in a) print i,a}' input Output: chr112 7 chr236 19 chr124 5 Desired output: chr1 1 2 7 chr2 3 6 19 chr1 2 4 5

9. Shell Programming and Scripting

(hard one) awk, copy matching 2 col & 10-12 rows, is it possible?

Hey guys, my first post here. I'm trying to use awk to copy all matching paragraphs from one file The file looks like this : Test Case Number 990990003099 Card Type CCCC Transaction Type Sale Entry Mode Keyed Account Number 4099562299219923 Transaction Amount 78.88 Description lorem...

10. Shell Programming and Scripting

awk to update file with sum of matching fields in another file

In the awk below I am trying to add a penalty to a score to each matching $1 in file2 based on the sum of $3+$4 (variable TL) from file1. Then the $4 value in file1 is divided by TL and multiplied by 100 (this valvue is variable S). Finally, $2 in file2 - S gives the updated $2 result in file2....

LEARN ABOUT SUSE

choptest

CHOPTEST(8C)															      CHOPTEST(8C)

NAME

       choptest - HylaFAX page chopping test program

SYNOPSIS

       /usr/sbin/choptest [ options ] input.tif

DESCRIPTION

       choptest is a program for testing the page chopping support in the HylaFAX software (specifically, in the faxq(8C) program).  choptest ana-
       lyzes a TIFF/F (TIFF Class F) file with 1-D MH- or 2-D MR-encoded data and reports what the automatic page chopping logic would do  if  the
       file were submitted for transmission.  Options are provided for controlling whether choptest checks the last page or all pages of the docu-
       ment, and what whitespace threshold to use in deciding if a page should be chopped.

OPTIONS

       -a	 Chop all pages in the document.  This is equivalent to setting the PageChop configuration parameter to  ``all'';  c.f.   hylafax-
		 config(5F).  By default only the last page of the document is considered.

       -t inches Set  the  minimum  whitespace	threshold  that  must  be present on a page for it to be chopped.  This is equivalent to the Page-
		 ChopThreshold configuration parameter; c.f.  hylafax-config(5F).  By default choptest requires that at least 3 inches of trailing
		 whitespace be present.

EXAMPLES

       The following shows a multi-page, high-resolution document.  Each page has insufficient whitespace for it to be chopped.

       hyla% ./choptest -a ~/tiff/pics/faxix.tif
       Chop pages with >=3" of white space at the bottom.
       Don't chop, found 67 rows, need 588 rows
       Don't chop, found 67 rows, need 588 rows
       Don't chop, found 67 rows, need 588 rows
       Don't chop, found 53 rows, need 588 rows
       Don't chop, found 91 rows, need 588 rows
       Don't chop, found 99 rows, need 588 rows
       Don't chop, found 47 rows, need 588 rows

SEE ALSO

       faxq(8C), hylafax-config(5F)

								  October 3, 1995						      CHOPTEST(8C)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

bash script, pattern matching + sum

Discussion started by: Wratholix

2. Shell Programming and Scripting

Sum all rows with an Awk one-liner

Discussion started by: jm4smtddd

3. UNIX for Dummies Questions & Answers

how to count number of rows and sum of column using awk

Discussion started by: pistachio

4. UNIX for Dummies Questions & Answers

Sum the rows number based on first field string value

Discussion started by: f_o_555