Sum of all lines in file without roundup with awk Post: 302343382

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to get the sum of all the lines in the file

Hi I have the following file, how I will calculate the sum of all the entries in the file. > cat abc 2 3 4 now the sum should be 2+3+4 = 9

2. Shell Programming and Scripting

Sum value from selected lines script (awk,perl)

Hello. I face this (2 side) problem. Some lines with this structure. ........... 12345678 4 12345989 13 12346356 205 12346644 74 12346819 22 ......... The first field (timestamp) is growing (or at least equal). 1)Sum the second fields if the first_field/500 are...

3. Shell Programming and Scripting

Summing over specific lines and replacing the lines with the sum using sed, awk

Hi friends, This is sed & awk type question. I have a text file which has numbers spread all over the file. I want to sum the series of numbers whenever i find it and produce an output file with the sum. For example ###start of input text file #### abc def ghi 1 2 3 4 kjld random...

4. Shell Programming and Scripting

Summing over specific lines and replacing the lines with the sum

Hi friends, This is sed & awk type question. It is slightly different from my previous question. I have a text file which has numbers spread all over the file. I want to sum the series of numbers (but no more than 10 numbers in series) whenever i find it and produce an output file with the...

5. Shell Programming and Scripting

Sum of 286th column using awk in a file

Hi, I am using the following code to find the sum of the values of column 286 in a file. It will have the Decimal values with the scale of 2. Delimiter is '|^' cut -d'|^' -f286 filename|cut -c3-| awk '{ x += $1 } END { printf("%.2f\n", x) }' There are around 50k records in this file...

6. UNIX for Dummies Questions & Answers

awk to sum column field from duplicate row/lines

Hello, I am new to Linux environment , I working on Linux script which should send auto email based on the specific condition from log file. Below is the sample log file Name m/c usage abc xxx 10 abc xxx 20 abc xxx 5 xyz ...

7. Shell Programming and Scripting

awk file sum results

I ran this script: #!/bin/bash ./disk-usage-JM.pl > jm_out InFile="jm_out" OutFile="jm_temp" awk '{if (!match(" \t",substr($0,1,1))) {server=$0; next} if (substr($0,1,1)==" ") {workspace=$0; next} print server,workspace,$0}' \ $InFile >$OutFile rm jm_out against this...

8. Shell Programming and Scripting

Sum duplicate values in text file through awk between dates

I need to sum values in text file in case duplicate row are present with same name and different value below is example of data in file i have and format i need. Data in text file 20170308 PM,U,2 PM,U,113 PM,I,123 DA,U,135 DA,I,113 DA,I,1 20170309 PM,U,2 PM,U,1 PM,I,123 PM,I,1...

9. 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....

10. UNIX for Beginners Questions & Answers

How to sum value of a column by range defined in another file awk?

I have two files, file1.table is the count table, and the other is the range condition file2.range. file1.table chr start end count N1 0 48 1 N1 48 181 2 N1 181 193 0 N1 193 326 2 N1 326 457 0 N1 457 471 1 N1 471 590 2 N1 590 604 1 N1 604 752 1 N1 752 875 1 file2.range...

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)