Sum in file based column Post: 303039374

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I sum one column based on another column?

Hi, I am new to this forum and new to awk. I have a file that contains 2 columns. Heres an example of what it looks like: 10 + 20 + 40 + 50 - 70 - So the file is tab-delimited. What I want to do is add 10 to column 1 whenever column 2 is + and substract 10 from column 1...

2. Shell Programming and Scripting

sum multiple columns based on column value

i have a file - it will be in sorted order on column 1 abc 0 1 abc 2 3 abc 3 5 def 1 7 def 0 1 -------- i'd like (awk maybe?) to get the results (any ideas)??? abc 5 9 def 1 8

3. Shell Programming and Scripting

Sum a column value based on multiple keys

Hi, I have below as i/p file: 5ABC 36488989 K 000010000ASB BYTRES 5PQR 45757754 K 000200005KPC HGTRET 5ABC 36488989 K 000045000ASB HGTRET 5GTH 36488989 K 000200200ASB BYTRES 5FTU ...

4. Shell Programming and Scripting

Sum Of Column Based On Column Condition

I have a following inputfile MT,AP,CDM,TTML,MUM,GS,SUCC,3 MT,AP,CDM,TTSL,AP,GS,FAIL,9 MT,AP,CDM,RCom,MAH,GS,SUCC,3 MT,AP,CDM,RTL,HP,GS,SUCC,1 MT,AP,CDM,Uni,UPE,GS,SUCC,2 MT,AP,CDM,Uni,MUM,GS,SUCC,2 TTSL,AP,GS,MT,MAH,CDM,SUCC,20 TTML,AP,GS,MT,MAH,CDM,FAIL,10...

5. UNIX for Dummies Questions & Answers

Sum based on column 1

i have file input aaa ccc,45567,rterw,1 bbb dcs,564543,hjghgh,1 aaa ccc,454,rterw,6 i want to sum based on column 1 expected output aaa ccc,7 bbb dcs,1

6. UNIX for Dummies Questions & Answers

Sum based on certain column

I have file 1 1/1/2013 A 553.0763397 96 16582 X1 X3 X5 X7 X9 1/1/2013 B 600.8333588 195 11992 X2 X3 X6 X7 X9 1/1/2013 B 459.8333588 195 11992 X1 X3 X6 X7 X9 1/2/2013 A 844.2973022 306 19555 X1 ...

7. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters...

8. UNIX for Dummies Questions & Answers

Sum third column in a file when 1 and 2 repeat

Hello, Below is a portion of a file I am working on: 2:15 3001 120 2:15 3001 26.25 2:15 3002 12.5 2:15 3002 15 9:45 3001 45 9:45 3001 45 9:45 3002 105 9:45 3005 180 9:45 3005 123.75 9:45 3005 15 I am trying to get the sum of column 3 for all repeated values of columns 1 and 2 (The...

9. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

Hi, I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column) The input is for example, after sorted: K00001 1 1 4 3...

10. Shell Programming and Scripting

Sum of a column as new column based on header in a script

Hello, I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically I/p c1,c2,c3,c4,c5 10,20,30,40,50 20,30,40,50,60 If i want to find sum only column c1, c3 and output it as c6,c7 O/p c1,c2,c3,c4,c5,c6,c7 10,20,30,40,50,30,70...

LEARN ABOUT FREEBSD

ses

SES(4)							   BSD Kernel Interfaces Manual 						    SES(4)

NAME

     ses -- SCSI Environmental Services driver

SYNOPSIS

     device ses

DESCRIPTION

     The ses driver provides support for all SCSI devices of the environmental services class that are attached to the system through a supported
     SCSI Host Adapter, as well as emulated support for SAF-TE (SCSI Accessible Fault Tolerant Enclosures).  The environmental services class gen-
     erally are enclosure devices that provide environmental information such as number of power supplies (and state), temperature, device slots,
     and so on.

     A SCSI Host adapter must also be separately configured into the system before a SCSI Environmental Services device can be configured.

KERNEL CONFIGURATION

     It is only necessary to explicitly configure one ses device; data structures are dynamically allocated as devices are found on the SCSI bus.

     A separate option, SES_ENABLE_PASSTHROUGH, may be specified to allow the ses driver to perform functions on devices of other classes that
     claim to also support ses functionality.

IOCTLS

     The following ioctl(2) calls apply to ses devices.  They are defined in the header file <cam/scsi/scsi_ses.h> (q.v.).

     SESIOC_GETNOBJ	Used to find out how many ses objects are driven by this particular device instance.

     SESIOC_GETOBJMAP	Read, from the kernel, an array of SES objects which contains the object identifier, which subenclosure it is in, and the
			ses type of the object.

     SESIOC_GETENCSTAT	Get the overall enclosure status.

     SESIOC_SETENCSTAT	Set the overall enclosure status.

     SESIOC_GETOBJSTAT	Get the status of a particular object.

     SESIOC_SETOBJSTAT	Set the status of a particular object.

     SESIOC_GETTEXT	Get the associated help text for an object (not yet implemented).  ses devices often have descriptive text for an object
			which can tell you things like location (e.g., "left power supply").

     SESIOC_INIT	Initialize the enclosure.

EXAMPLE USAGE

     The files contained in <usr/share/examples/ses> show simple mechanisms for how to use these interfaces, as well as a very stupid simple moni-
     toring daemon.

FILES

     /dev/sesN	    The Nth SES device.

DIAGNOSTICS

     When the kernel is configured with DEBUG enabled, the first open to an SES device will spit out overall enclosure parameters to the console.

HISTORY

     The ses driver was written for the CAM SCSI subsystem by Matthew Jacob.  This is a functional equivalent of a similar driver available in
     Solaris, Release 7.

BSD
								 January 29, 2000							       BSD