awk sum columns Post: 302297670

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find percent between sum of 2 columns awk help

Hi I'm new to this forum and I'm a beginner when it comes to shell and awk programming. But I have the following problem: I have 5 csv files (data1.csv, data2.csv, etc.) and need to calculate the average between the total sum of the 1st and 7 column. csv example:...

2. Shell Programming and Scripting

help sum columns by break in first column with awk or sed or something.

I have some data that is something like this? item: onhand counted location ITEM0001 1 0 a1 ITEM0001 0 1 a2 ITEM0002 5 0 b5 ITEM0002 0 6 c1 I want to sum up...

3. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I...

4. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns satisfy the condition

HI All, I'm embedding SQL query in Script which gives following output: Assignee Group Total ABC Group1 17 PQR Group2 5 PQR Group3 6 XYZ Group1 10 XYZ Group3 5 I have saved the above output in a file. How do i sum up the contents of this output so as to get following output: ...

5. Shell Programming and Scripting

awk sum of all columns needs to print exact amount

Hi I have attached txt file as input, and i'm able to calculate sum of columns at the end but the format of sum is not coming up right. awk -F"," '{for (i=4;i<=NF;i++) sum+=$i}{print}; END { sum="Total:"; for (i=1;i<=NF;i++) {printf sum ","} print "\n"}' input.txt check the o/p file, at...

6. UNIX for Beginners Questions & Answers

Group by columns and add sum in new columns

Dear Experts, I have input file which is comma separated, has 4 columns like below, BRAND,COUNTRY,MODEL,COUNT NIKE,USA,DUMMY,5 NIKE,USA,ORIGINAL,10 PUMA,FRANCE,DUMMY,20 PUMA,FRANCE,ORIGINAL,15 ADIDAS,ITALY,DUMMY,50 ADIDAS,ITALY,ORIGINAL,50 SPIKE,CHINA,DUMMY,1O And expected output add...

7. Shell Programming and Scripting

Sum of columns using awk

Hello everyone I am a beginner in Shell scripting. Need your help to achieve desired result. I have a file (sample format below) 001g8aX0007jxLz xxxxxxxxxxxxxxx 9213974926411 CO-COMM-133 CO-L001-DLY 7769995578239 44938 1 1 ...

8. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For...

9. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

10. UNIX for Advanced & Expert Users

Need Optimization shell/awk script to aggreagte (sum) for all the columns of Huge data file

Optimization shell/awk script to aggregate (sum) for all the columns of Huge data file File delimiter "|" Need to have Sum of all columns, with column number : aggregation (summation) for each column File not having the header Like below - Column 1 "Total Column 2 : "Total ... ......

LEARN ABOUT HPUX

sum

sum(1)							      General Commands Manual							    sum(1)

NAME

       sum - print checksum and block or byte count of file(s)

SYNOPSIS

       [file ...]

   Remarks
       is obsolescent and should not be used in new applications that are intended to be portable between systems.  Use instead (see cksum(1)).

DESCRIPTION

       calculates  and	prints to standard output a checksum for each named file, and also prints the size of the file in 512 byte blocks, rounded
       up.

       The default algorithm is a 16-bit sum of the bytes in which overflow is ignored.   Alternate  algorithms  can  be  selected  with  the  and
       options.

       Standard input is used if no file names are given.

       is typically used to verify data integrity when copying files between systems.

   Options
       recognizes the following options:

	      Use an alternate algorithm in which the 16-bit sum is right rotated
			with each byte in computing the checksum.

	      Use the 32-bit cyclical redundancy check (CRC) algorithm used by

RETURN VALUE

       returns the following values upon completion:

	      All files were processed successfully.

	      One or more files could not be read or some other error occurred.

       If an inaccessible file is encountered, continues processing any remaining files, but the final exit status is affected.

DIAGNOSTICS

       Read error conditions are indistinguishable from end of file on most devices; check the block or byte count.

WARNINGS

       This  command  is  likely  to  be withdrawn from X/Open standards.  Applications using this command might not be portable to other vendors'
       platforms. The usage of cksum(1) is recommended.

SEE ALSO

       cksum(1), wc(1).

STANDARDS CONFORMANCE

																	    sum(1)