summing according to the column

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Mismatch in summing a column in UNIX

Hello, I am facing issue in summing up a column in unix.I am displaying a column sum up to 4 decimal places and below is the code snippet sed '1d' abc.csv | cut -d',' -f7 | awk '{s+=$1}END{ printf("%.4f\n",s)}' -170552450514.8603 example of data values in the column(not...

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

3. Shell Programming and Scripting

Summing a number column

hi All, i have a file in which only one column is there., test.txt ====== -900.01 -900.02 -900.03 -900.04 -900.05 -900.06 -900.07 -900.08 -900.09 900.01 900.02 900.03 900.04 900.05

4. 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)....

5. Shell Programming and Scripting

Summing up rows data regarding 1st column

Dear all, I have one file like LABEL A B C D E F G H I J K L M N G02100 64651.3 25630.7 8225.21 51238 267324 268005 234001 52410.9 18598.2 10611 10754.7 122535 267170 36631.4 G02100 12030.3 8260.15 8569.91 ...

6. Shell Programming and Scripting

summing from two different files

I have two files hhhh 3674.00 a 75 1535 183 2134 291 2452 442 2738 704 3048 a 1007 3549 1282 4413 1494 5001 1631 5217 1954 5610 a 2540 5832 3248 6080 3629 6264 4851 6600 7004 6985 ...

7. Shell Programming and Scripting

Summing column value - using PERL

I'm new to perl programming. I've a csv file as below. 20100221, abc_1, 200 20100221, abc_4, 350 20100221, opq_3, 200 20100221, abc_5, 220 20100221, xyz_1, 500 20100221, abc_2, 500 20100221, abc_3, 100 20100221, xyz_2, 700 20100221, opq_2, 350 20100221, xyz_3, 100 20100221, opq_1, 230...

8. Shell Programming and Scripting

summing values of a column

I have a file which contains data as below: ----------------------------------------------------------------------------------------------- GSPWeb Statistics for the period of last 20 days...

9. Shell Programming and Scripting

A summing issue

Hi All, Here is the problem: The input file is like as per below. Each record has 30 chars in total. Have to add the first 17 and the next 13 and append the output. Total records can vary. 000000004728800000000000003908 000000003005100000000000002484 000000002602200000000000002151...

10. Shell Programming and Scripting

Summing on column

Hi Friends How to do sum on a column? I have a file like: FRED 500.01 TX SMITH 50.10 NY HARRY 5.00 CA 555.11 Sum on second column. I am trying using nawk like nawk 'BEGIN {FS="|"}; {printf $1"+"}' Thanks a lot for your help S :)

LEARN ABOUT CENTOS

strverscmp

STRVERSCMP(3)						     Linux Programmer's Manual						     STRVERSCMP(3)

NAME

       strverscmp - compare two version strings

SYNOPSIS

       #define _GNU_SOURCE	   /* See feature_test_macros(7) */
       #include <string.h>

       int strverscmp(const char *s1, const char *s2);

DESCRIPTION

       Often  one  has	files  jan1, jan2, ..., jan9, jan10, ...  and it feels wrong when ls(1) orders them jan1, jan10, ..., jan2, ..., jan9.	In
       order to rectify this, GNU introduced the -v option to ls(1), which is implemented using versionsort(3), which again uses strverscmp().

       Thus, the task of strverscmp() is to compare two strings and find the "right" order, while strcmp(3) finds only	the  lexicographic  order.
       This function does not use the locale category LC_COLLATE, so is meant mostly for situations where the strings are expected to be in ASCII.

       What  this  function  does  is the following.  If both strings are equal, return 0.  Otherwise find the position between two bytes with the
       property that before it both strings are equal, while directly after it there is a difference.  Find the largest consecutive digit  strings
       containing  (or starting at, or ending at) this position.  If one or both of these is empty, then return what strcmp(3) would have returned
       (numerical ordering of byte values).  Otherwise, compare both digit strings numerically, where digit strings with one or more leading zeros
       are  interpreted  as  if  they have a decimal point in front (so that in particular digit strings with more leading zeros come before digit
       strings with fewer leading zeros).  Thus, the ordering is 000, 00, 01, 010, 09, 0, 1, 9, 10.

RETURN VALUE

       The strverscmp() function returns an integer less than, equal to, or greater than zero if s1 is found, respectively, to	be  earlier  than,
       equal to, or later than s2.

CONFORMING TO

       This function is a GNU extension.

SEE ALSO

       rename(1), strcasecmp(3), strcmp(3), strcoll(3)

COLOPHON

       This  page is part of release 3.53 of the Linux man-pages project.  A description of the project, and information about reporting bugs, can
       be found at http://www.kernel.org/doc/man-pages/.

GNU
								    2001-12-19							     STRVERSCMP(3)

UNIX for Dummies Questions & Answers