I need to calculat the sum of the particular field in text file. And the datatype of the field in file is decimal(18,2). If the file is small, then I am facing any problem. But the file is huge, then the result is converted into exponential format.
I tried using various command thr this forum, but still facing the problem.
Thanks in advance.
Moderator's Comments:
This is the 3rd homework violation. The homework template must be filled in when posting to the Homework & Coursework forum. This thread is closed.
Last edited by Don Cragun; 09-02-2013 at 07:46 AM..
The file content is dynamic and using this format:
name1 number1
name2 number2
name3 number3
name4 number4
....................
Need a smooth way to calculate the sum of all the numbers in that file (number1 + number2 + number3 + number4........ = total ) (11 Replies)
how to sum particular field in text file
i am having text file like
222|4000|abc
333|5000|xyz
444|6000|mno
i want sum of second field
i.e 4000+5000+6000
can u pls help (3 Replies)
Hi,
I wanted a script to find sum of files for a particular date, below is my script
ls -lrt *.req | nawk '$6 == "Aug"' | nawk '$7 == "1"'| awk '{sum = sum + $5} END {print sum}'
However, i get the error below
/usr/bin/ls: arg list too long
How do i fix that.
Many thanks before. (2 Replies)
Hi Everyone,
($total+=$_) for @record;
assume @record=(1,2,3), so the result is 6.
if @record=("1 3","2 3","3 3"), would like to sum up the 2nd field of this array, the result is 9.
i tried " ($total+=$) for @record ", cannot, please advice.
Thanks
---------- Post updated at 03:45... (1 Reply)
this is part of a KT i am going thru.
i am writing a script in bash shell, linux where i have 2 columns where 1st signifies the nth hour like 00, 01, 02...23 and 2nd the file size.
sample data attached.
Desired output is 3 columns which will give the nth hour, number of entries in nth hour and... (3 Replies)
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)