I need to sum up the values in field nr 5 in a data file that contains some file listing. The 5th field denotes the size of each file and following are some sample values.
I tried the following code in a shell script.
But it does not add up the numbers. The result is the sum of values until it encounters the first comma in each of the numbers.
I also tried doing a substitution before summing up (as below), but even that did not give expected result.
Please suggest if you have encountered such a scenario.
Hi,
i want to sum all nubers in one column. Example:
12.23
11
23.01
3544.01
I'm trying to do this in awk, but it doesn't work properly.
Seems like awk is summing only integers, for example:
12
11
23
3544
It cuts off numbers after dot.
I used this command:
akw /text/ file.txt |nawk... (1 Reply)
I have a file that looks like this:
G. KRESSLAR
9618 W. APPALOOSA DRIVE
SUN CITY, AZ 85373
SHIRLEY ALLEN
7272 W. VIA MONTOYA DRIVE
GLENDALE, AZ 85310
LOUIS VALDEZ
244441 N. 86TH AVENUE
PEORIA, AZ 85383
DONNA NEWBON
3231 W. DENTON #D
PHOENIX, AZ 85017
SARAH WILSON
6534 W. PALO... (3 Replies)
hello im looking for short way to sum numbers from stdout the way i found to do it is to long for me i wander if there is shorter way to do it
ok it 2 stage action
this will make the list of number in to file sum.txt
grep -c include *.c | awk '{l=split($0,a,":");print a;}' > sum.txt
this... (1 Reply)
Hello,
I have a file of text and numbers from which I want to extract certain fields and write it to a new file. I would use awk but unfortunately the input data isn't always formatted into the correct columns. I am using tcsh.
For example, given the following data
I want to extract:
and... (3 Replies)
cat *.out |grep "<some text>" | awk '{print $6}'
For ex,This will reutrn me
11111
22222
is it possible to add these two numbers in the above given command itself?I can write this to a file and find the sum.
But I prefer to this calculation in the above given line itself.
Any... (3 Replies)
I basically have a file where I had to do a bunch of greps to get a list of numbers
example: a file called numbers.txt
10000
10000
superman
10000
batman
10000
10000
grep '100' * |
10000
10000
10000
10000
10000 (2 Replies)
Hi Guys,
I want to remove commas from just the numbers in the file.
So both sides of the comma should be numbers.
Input file
Johan
1,234 nb
jan
123,3
hi, hello, bye
12,345,54
hejhej
Desired output:
Johan
1234 nb
jan (6 Replies)
How to split the file and have suffix with formatted numbers
Tried the following code
awk '{filename="split."int((NR-1)/2)".txt"; print >> filename}' split.txt
Current Result
Expected Result (21 Replies)
Discussion started by: bobbygsk
21 Replies
LEARN ABOUT REDHAT
sum
sum(n) sum sum(n)
NAME
sum - calculate a sum(1) compatible checksum
SYNOPSIS
package require Tcl 8.2
package require sum ?1.0?
::crc::sum ?-format format? message
::crc::sum ?-format format? -filename file
DESCRIPTION
This package provides a Tcl-only implementation of the sum(1) command which calculates a 16 bit checksum value from the input data. The
BSD sum algorithm is used by default but the SysV algorithm is also available.
COMMANDS
::crc::sum ?-format format? message
::crc::sum ?-format format? -filename file
The command takes string data or a file name and returns a checksum value calculated using the sum(1) algorithm. The result is for-
matted using the format(n) specifier provided or as an unsigned integer (%u) by default.
OPTIONS -filename name
Return a checksum for the file contents instead of for parameter data.
-format string
Return the checksum using an alternative format template.
EXAMPLES
% crc::sum "Hello, World!"
37287
% crc::sum -format 0x%X "Hello, World!"
0x91A7
% crc::sum -file sum.tcl
13392
SEE ALSO sum(1), cksum(n), crc32(n)
AUTHORS
Pat Thoyts
KEYWORDS
sum, cksum, checksum, crc, crc32, cyclic redundancy check, data integrity, security
crc 1.0 sum(n)