summing values of a column Post: 302346803

10 More Discussions You Might Find Interesting

1. 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 :)

2. UNIX for Dummies Questions & Answers

summing according to the column

I have a text file with two columns the first column is an integer and the second column is date how do i sum up the first column according to the date example 123 jan1 232 jan1 473 jan2 467 jan2 356 jan3 376 jan3 my result should be 355 jan1 940 jan2 732 jan3 how do i...

3. Shell Programming and Scripting

summing up iostat values in AIX

Friends, I have to run iostat -d on my AIX machine and print the sum of the output in tps column per iteration. can any one pls guide me how to do this using awk. here is the sample output iostat -d 2 2 | awk '!/System/ && !/Disks/ && !/cd/ && !/^$/ {print $4}' 2.0 3.0 1.0 3.0...

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

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

6. Shell Programming and Scripting

Summing values in columns

Basically I have to process a text file which has been sorted this way: John 12 John 13 John 10 John 900 Peter 20 Peter 30 Peter 32 The first column is a name, and the second an arbitrary value, both delimited by a space. How can I sum them up such that it would become: John 935...

7. Shell Programming and Scripting

reading a script and summing some values

I need help reading and summing some values in a file that looks like the following. This is an Oracle trace file. Oracle has as utility to do this,but it doesn't work properly unless my sql statement is done. I want to read the file and sum up some values to let me know how the query/job is...

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

9. Shell Programming and Scripting

Summing up values of rows of numbers

data file contains failed=24 error=23 error=163 failed=36 error=903 i need to get a total count of each value above. i'm looking for the most efficient method to do this as the datafile i provided is just a sample. the actual data can be several hundred thousands of lines. so from...

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

LEARN ABOUT HPUX

rpccp_remove_member

remove member(1m)														 remove member(1m)

NAME

       remove member - Removes a specified member from a group

SYNOPSIS

       rpccp remove member  group-entry-name -m member [-s syntax]

OPTIONS

       Declares  the  entry  name  of the group member to be removed (required).  Indicates the name syntax of the entry name (optional). The only
       value for this option is the dce name syntax, which is the default name syntax. Until an alternative name syntax becomes available,  speci-
       fying the -s option is unnecessary.

ARGUMENTS

       Indicates  the  name  of  the  target group.  For an entry in the local cell, you can omit the cell name and specify only the cell-relative
       name.

DESCRIPTION

       The remove member command removes a specified member from a specified group.

   Privilege Required
       You need read permission and write permission to the CDS object entry (the target group entry).

NOTE

       This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.

EXAMPLES

       The following commands run RPCCP and remove the member /.:/LandS/anthro/Cal_host_2 from the group  /.:/LandS/dept/Calendar_group:  $  rpccp
       rpccp>  remove  member	  >  -m /.:/LandS/anthro/Cal_host_2   > /.:/LandS/anthro/Calendar_group The following command removes the member
       /.:/LandS/anthro/Cal_host_3 from the group /.:/LandS/anthro/Calendar_group: $ rpccp remove member   > -m /.:/LandS/anthro/Cal_host_3    >
       /.:/LandS/anthro/Calendar_group

RELATED INFORMATION

       Commands: add member(1m), remove group(1m), show group(1m)

																 remove member(1m)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Summing on column

Discussion started by: sbasetty

2. UNIX for Dummies Questions & Answers

summing according to the column

Discussion started by: ramky79

3. Shell Programming and Scripting

summing up iostat values in AIX

Discussion started by: achak01

4. Shell Programming and Scripting

Awk: Summing values with group criteria

Discussion started by: gianluca2