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 Replies)
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... (2 Replies)
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... (1 Reply)
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:
... (7 Replies)
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... (2 Replies)
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... (0 Replies)
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 Replies)
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... (3 Replies)
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... (3 Replies)
Discussion started by: karthik adiga
3 Replies
LEARN ABOUT CENTOS
gsf-office-thumbnailer
GSF-OFFICE-THUMBNAILER(1) GNOME GSF-OFFICE-THUMBNAILER(1)NAME
gsf-office-thumbnailer - office files thumbnailer for the GNOME desktop
SYNOPSIS
gsf-office-thumbnailer [OPTIONS] infile outfile
DESCRIPTION
This manual page briefly documents the gsf-office-thumbnailer command.
gsf-office-thumbnailer is used internally by GNOME applications such as nautilus to generate thumbnails of several types of office applica-
tion files. While it is possible to invoke it manually, it is usually invoked automatically by nautilus.
OPTIONS
This program follows the usual GNU command line syntax, with single letter options starting with a single dash (`-') and longer options
starting with two dashes (`--').
Main options
-i, --input=filename
Name of file for which to create a thumbnail
-o, --output=filename
Name of the file in which to store the thumbnail
-s, --size=N
Size of thumbnail in pixels; the thumbnail will be at most N*N pixels large.
Help options
-?, --help
Display a brief usage message
LICENSE
gsf-office-thumbnailer is licensed under the terms of version 2.1 of the GNU Lesser General Public License (LGPL) as published by the Free
Software Foundation. For information on this license look at the source code that came with the software or see the GNU project page
<http://www.gnu.org/>.
AUTHOR
gsf-office-thumbnailer's primary author is Federico Mena-Quintero <federico@novell.com>.
The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.
gsf August 17, 2005 GSF-OFFICE-THUMBNAILER(1)