Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help summing a file using awk
Top Forums Shell Programming and Scripting Help summing a file using awk Post 302785883 by Drenhead on Tuesday 26th of March 2013 01:37:43 PM
Old 03-26-2013
Help summing a file using awk
I'm trying to sum a text file using AWK. Here is an example of the file:

Code:
600|3H68|        46
600|3H69|        46
600|3H6F|       290
600|3H6G|        24
600|3HDY|         1
600|3HDY|         3
600|3HE0|         1
600|3HE0|         3

I would like to sum the third field if the first two fields are the same.

For example, the last 2 lines, I would like them to sum up and have
600|3HE0| 4

Is this possible using AWK?

I tried something like this, but it gave strange results:
Code:
awk 'BEGIN { FS = "|" } ; '{ arr[$1 "|" $2] += $3 } END {for (i in arr) {print i "|" arr[i] } }' count_all.txt

I appreciate any help you can provide.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk scripting - matching records and summing up time

Hello. I just found out about awk, and it appears that this could handle the problem I'm having right now. I first stumbled on the thread How to extract first and last line of different record from a file, and that problem is almost similar to mine. In my case, an ASCII file will contain the... (0 Replies)
Discussion started by: Gonik
0 Replies

2. Shell Programming and Scripting

Awk: Summing values with group criteria

Hi Guys, I have a text file with ";" like separator F1;F2;F3;F4;F5 444;100041;IT;GLOB;1800000000 444;100041;TM;GLOB;1000000000 444;10300264;IT;GLOB;2000000000 444;10300264;IT;GLOB;2500000000 I have to sum the cullums F5 for same F2 and F3 collums The result must be: ... (7 Replies)
Discussion started by: gianluca2
7 Replies

3. Shell Programming and Scripting

Summing up a matrix using awk

Hi there, If anyone can help me sorting out this small task would be great. Given a matrix like the following: 100 3 3 3 3 3 ... 200 5 5 5 5 5 ... 400 1 1 1 1 1 ... 500 8 8 8 8 8 ... 900 0 0 0 0... (5 Replies)
Discussion started by: JRodrigoF
5 Replies

4. Shell Programming and Scripting

Using awk to summing from a given line

My file is something like this : 03.097 03.094 03.093 03.095 03.091 04.089 06.093 07.225 08.196 06.097 06.094 05.096 04.086 I'd like to sum it from a given line to another one , e.g.: from line 10 until line 20 What s the awk way solving this ? (1 Reply)
Discussion started by: firelink
1 Replies

5. Shell Programming and Scripting

Please Help!!!! Awk for summing columns based on selected column value

a,b,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,aa,bb,cc,dd,ee,ff,gg,hh,ii a thru ii are digits and strings.... The awk needed....if coloumn 9 == i (coloumn 9 is string ), output the sum of x's(coloumn 22 ) in all records and sum of y's (coloumn 23 ) in all records in a file (records.txt).... (6 Replies)
Discussion started by: BrownBob
6 Replies

6. UNIX for Dummies Questions & Answers

Summing lines in a file

Can anyone tell me how sum values in each record of a file and append that value to the end? For instance a typical record will be: FY12,Budget,771100,,,,,,,,,250,-250 I'd like the record to become FY12,Budget,771100,,,,,,,,,250,-250,0 which can be put into another file. Thank you. (6 Replies)
Discussion started by: LearningLinux2
6 Replies

7. Shell Programming and Scripting

awk summing specific lines and fields

Hi I would like to know if it is possible to sum some specific fields. I have this x;x;x;x;x;x;x;x;467,390,611 Bytes;0.435291 GB;0.062247 GB;0.373045 GB;11,225;157 a;a;a;a;a;a;a;a;13,805,156,846 Bytes;12.857054 GB;1.838559 GB;11.018495 GB;151,063;18,933 b;b;b;b;b;b;b;b;232,797,478,723... (5 Replies)
Discussion started by: nakaedu
5 Replies

8. UNIX Desktop Questions & Answers

Summing file sizes

I was just curious about how to sum the total file size of a certain type of file. For instance: $find . -name "*.aif" will print out the paths to each .aif file. Instead of printing, how could one sum the total space used by all of the aif files? Thanks! Please use code tags (3 Replies)
Discussion started by: Alexander4444
3 Replies

9. Shell Programming and Scripting

Summing all fields in a file

I was playing around to see how stuff works, and was trying to sum all fields in a file. cat file 1 2 3 4 5 6 7 8 9 10 11 12 I made this script: awk 'BEGIN {OFS=RS}{$1=$1}{s+=$0} END {print "sum="s}' file This gives 15, why not 78? I test it like this awk 'BEGIN... (5 Replies)
Discussion started by: Jotne
5 Replies

10. 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 (1 Reply)
Discussion started by: jacobs.smith
1 Replies

LEARN ABOUT REDHAT

pbm2ppa

pnm2ppa(5 Feb 2000)													       pnm2ppa(5 Feb 2000)

NAME

       pbm2ppa - convert portable bitmap (PBM) to HP's Printing Performance Architecture (PPA) file format

SYNOPSIS

       pbm2ppa [options] [ <infile] > [ <outfile]> ] ]

DESCRIPTION

       Reads  portable bitmap (PBM) format as input.  Outputs a stream suitable for processing by  Hewlett-Packard's range of Printing Performance
       Architecture (PPA) printers.  pnm2ppa supports the HP 710c, 712c, 720c, 722c, 820c, and 1000c series printers.

       (Portable bitmap (PBM) format output can be produced from PostScript(tm) input by the GhostScript driver "pbmraw".)

OPTIONS

       infile Input file infile is either a path to a file or device, or '-' to indicate stdin (defaults to stdin)

       outfile
	      Output file outfile is either a path to a file or device, or '-' to indicate stdout (defaults to stdout)

       -b bottommargin
	      Sets the bottom margin bottommargin in units of 1/600 inches (e.g.,  -b 150 = 0.25")

       -d     Displays the current configuration

       -f configfile
	      Overrides reading the configuration from /etc/pnm2ppa.conf, and uses configfile instead.

       -h     Displays program usage

       -l leftmargin
	      Sets the left margin leftmargin in units of 1/600 inches (e.g., -l 150 = 0.25")

       -r rightmargin
	      Sets the right margin rightmargin in units of 1/600 inches (e.g., -r 150 = 0.25")

       -s papersize
	      Sets the paper size. Possible values for papersize are a4 (A4), letter or us (US Letter, 8.5"x11"), and legal (US Legal,	8.5"x14").
	      The default is US Letter.

       -t topmargin
	      Sets the top margin topmargin in units of 1/600 inches (ie -t 150 = 0.25")

       -v printertype
	      Selects the printer model.  Possible values of printertype are: 710, 712, 720, 722, 820 and 1000.  The default is the HP DeskJet 7X0
	      Series (710, 712, 720, 722).

       -x xoffset
	      Sets the x-offset xoffset from the left of the page. Units are 1/600 inches

       -y yoffset
	      Sets the y-offset yoffset from the top of the page. Units are 1/600 inches

NOTES

       The configuration file is read in first. Command line arguments then modify the resulting definitions.

       The -x and -y options accumulate. The -v option resets all definitions back to an inbuilt default for  that  printer  and  should  be  used
       before subsequent -b -l -r, -t,	-x, and -y arguments.

SEE ALSO

       pbm(5)

FILES

       /etc/pbm2ppa.conf
	      Default configuration file

AUTHOR

       This code is licensed under the GNU Public License version 2. See LICENSE for details.

       (c) 1998  Tim Norman

HISTORY

       This  program was written by Tim Norman. It originally supported black and white output on the 820 series. This program is almost obsolete;
       its successor pnm2ppa will support color printing.

BUGS

       This is a stable driver, but does not support color printing.

															       pnm2ppa(5 Feb 2000)
All times are GMT -4. The time now is 08:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy