Sum of columns and format the output Post: 302907087

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

Hi Experts, I am adding a column of numbers with awk , however not getting correct output: # awk '{sum+=$1} END {print sum}' datafile 2.15291e+06 How can I getthe output like : 2152910 Thank you.. # awk '{sum+=$1} END {print sum}' datafile 2.15079e+06

2. Shell Programming and Scripting

Sum of three columns - in 4N columns file

Hi All, happy new year. I have a file with 4xN columns like 0.0000e+00 0.0000e+00 7.199E+07 7.123E+07 6.976E+07 6.482E+07 5.256E+07 2.523E+07 0.0000e+00 0.0000e+00 8.641E+07 8.550E+07 8.373E+07 7.780E+07 6.309E+07 3.028E+07...

3. UNIX for Dummies Questions & Answers

Sum of all columns in all files in one output file

If I have say 4 files like this: File1: 1 3 4 7 7 0 5 7 5 9 1 2 7 4 8 File2: 1 4 6 2 5 7 1 2 3 6 0 3 0 3 8 File3:

4. Shell Programming and Scripting

Format the value of sum

I have a list of values ( in Kb) I have the following code to sum up the values and convert the total to GB cat list 701368101370 101370101370 801554101370 701636101370 101757101370 101876101370 901951101370 And this is the output of my script awk '{ s += $1 } END {...

5. Shell Programming and Scripting

Format output into columns, variables with multiple entries

Hello all, I've got a script that collects data on file systems and prints out specific data about each. I've formatted headers w/ printf like so. printf "\033 and I had the content of the varibles printed out beneath those columns like so: printf...

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

7. Shell Programming and Scripting

Get the SUM of TWO columns SEPARATELY by doing GROUP BY on other columns

My File looks like: "|" -> Field separator A|B|C|100|1000 D|E|F|1|2 G|H|I|0|7 D|E|F|1|2 A|B|C|10|10000 G|H|I|0|7 A|B|C|1|100 D|E|F|1|2 I need to do a SUM on Col. 5 and Col.6 by grouping on Col 1,2 & 3 My expected output is: A|B|C|111|11100

8. Shell Programming and Scripting

How to format output in columns by appending multi lines one by one?

Hi, I need to display output in below format Customer : Apr 24 16:31 Customer_Name_111121.txt |---Space---|Apr 24 16:32 Customer_Name _111121. txt |---Space---|Apr 24 16:34 Customer_Name_111112. txt |---Space---|Apr 24 16:35 Customer_Name _222223. txt |---Space---|Apr 24 16:37...

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

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

LEARN ABOUT SUNOS

socal

socal(7D)							      Devices								 socal(7D)

NAME

       socal - Serial Optical Controller for Fibre Channel Arbitrated Loop (SOC+) device driver

SYNOPSIS

       socal@sbus-slot,0

DESCRIPTION

       The Fibre Channel Host Bus Adapter is an SBus card which implements two full duplex Fibre Channel interfaces.  Each Fibre Channel interface
       can connect to a Fibre Channel Arbitrated Loop (FC-AL).

       The  socal device driver is a nexus driver and implements portions of the FC-2 and FC-4 layers of FC-AL.

FILES

       /kernel/drv/socal       ELF Kernel Module

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Architecture		     |SPARC			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       sbus(4), sf(7D), ssd(7D)

       Writing Device Drivers

       ANSI X3.230-1994, Fibre Channel Physical and Signalling Interface (FC-PH)

       ANSI X3.272-1996, Fibre Channel Arbitrated Loop (FC-AL)

       Fibre Channel Private Loop SCSI Direct Attach (FC-PLDA)

DIAGNOSTICS

       The messages described below  may appear on system console in addition to being logged.

       On the console, these messages are preceded by:

       socal%d: port %a

       where  %d is the instance number of the	socal controller and  %a is the port on the host adapter.

       Fibre Channel Loop is ONLINE

	   The Fibre Channel loop is now online.

       Fibre Channel Loop is OFFLINE

	   The Fibre Channel loop is now offline.

       attach failed: device in slave-only slot.

	   Move soc+ card to another slot.

       attach failed: bad soft state.

	   Driver did not attach, devices will be inaccessible.

       attach failed: unable to alloc xport struct.

	   Driver did not attach, devices will be inaccessible.

       attach failed: unable to map eeprom

	   Driver was unable to map device memory; check for bad hardware.  Driver did not attach to device, devices will be inaccessible.

       attach failed: unable to map XRAM

	   Driver was unable to map device memory; check for bad hardware.  Driver did	not attach to device, devices will be inaccessible.

       attach failed: unable to map registers

	   Driver was unable to map device registers; check for bad hardware.  Driver  did not attach to device, devices will be inaccessible.

       attach failed: unable to access status register

	   Driver was unable to map device registers; check for bad hardware.  Driver  did not attach to device, devices will be inaccessible.

       attach failed: unable to install interrupt handler

	   Driver was not able to add the interrupt routine to the kernel.  Driver  did not attach to device, devices will be inaccessible.

       attach failed: unable to access host adapter XRAM

	   Driver was unable to access device RAM; check for bad hardware.  Driver  did not attach to device, devices will be inaccessible.

       attach failed: unable to write host adapter XRAM

	   Driver was unable to write device RAM; check for bad hardware.  Driver  did not attach to device, devices will be inaccessible.

       attach failed: read/write mismatch in XRAM

	   Driver was unable to verify device RAM; check for bad hardware.  Driver  did not attach to device, devices will be inaccessible.

SunOS 5.10							    9 May 1997								 socal(7D)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

Discussion started by: rveri

2. Shell Programming and Scripting

Sum of three columns - in 4N columns file

Discussion started by: f_o_555

3. UNIX for Dummies Questions & Answers

Sum of all columns in all files in one output file

Discussion started by: cosmologist

4. Shell Programming and Scripting

Format the value of sum

Discussion started by: Sara_84