12-24-2015
What operating system and shell are you using?
What have you tried to solve this problem?
Please show us exactly what output you are hoping to produce from your sample input. (Note that the string CLP04 does not appear anywhere in your sample input??? Note that there are no = characters in your sample input either??? What values are you trying to sum???)
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to extracting the sum of all varibles listed in a file.
The code is as follows
##### FILE1 ########
Value1:2
Value2:2
Value3:6
Value4:5
##### shell script ######
#!/bin/sh
total=0 (2 Replies)
Discussion started by: eagercyber
2 Replies
2. Shell Programming and Scripting
Hi,consider this fields,
$1 $2 $3
981 0 1
984 0 4
985 1 0
987 0 2
990 0 0
993 0 3
995 2 0
996 0 1
999 0 4
for each occurence of zero in column $2 and $3 I need to sum $1 fields, so for example, in this piece of code the result of $1 is 8910. I'm sure... (2 Replies)
Discussion started by: cv313x
2 Replies
3. Shell Programming and Scripting
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 (3 Replies)
Discussion started by: rveri
3 Replies
4. Shell Programming and Scripting
Hi all,
I need to sum values for fields in a delimited file as below:
2010-03-05|||
2010-03-05|||123
2010-03-05|467.621|369.532|
2010-03-06|||
2010-03-06||2|
2010-03-06|||444
2010-03-07|||
2010-03-07|||
2010-03-07|655.456|1019.301|
Code used is:
nawk -F "|" ' { sum +=... (7 Replies)
Discussion started by: Katabatic
7 Replies
5. Shell Programming and Scripting
Hi,
I am unable sum of each column in the loop usng awk command.
Awk is not allowing the parameters in the command.
i am facing the below error.
awk: 0602-562 Field $() is not correct.
Source file
abc.txt
100,200,300,400,500,600,700,800,900
101,201,301,401,501,601,701,801,901
... (1 Reply)
Discussion started by: number10
1 Replies
6. Shell Programming and Scripting
Hi,
I have a file with header, detail and trailer records.
HDR|111
DTL|abc|100|xyz
DTL|abc|50|xyz
TRL|150
I need to add the values in 3rd field from DTL records.
Using awk, I am doing it as follows:
awk -F'|' '$1=="DTL"{a += $3} END {print a}' <source_file>
However, I want to... (3 Replies)
Discussion started by: delta21
3 Replies
7. Shell Programming and Scripting
pcmpath query device |awk 'BEGIN{print "DEVICE NAME\tSERIAL"} /DEVICE NAME/ {printf "%s\t", $5; getline; print substr($2, length($2)-3)}'
This script returns output like below to pull out "DEVICE NAME SERIAL".
......
hdisk28 110B
hdisk29 1112
hdisk30 1115
hdisk31 1116
hdisk32 1128... (2 Replies)
Discussion started by: Daniel Gate
2 Replies
8. Shell Programming and Scripting
Hi
i have to calculate some numbers, column by column.
Herfore i used a for-loop..
for i in {4..26};do awk -F"," '{x'$i'+=$'$i'}END{print '$i'"\t" x'$i'}' file.tmp;done
----- printout -----
4 660905240
5 71205272
6 8.26169e+07
7 8.85961e+07
8 8.60936e+07
9 7.42238e+07
10 5.6051e+07... (7 Replies)
Discussion started by: IMPe
7 Replies
9. Shell Programming and Scripting
Hi all,
I have one host i need to run in loop to check the capacity from different frame and get the output to one file and sum it and convert to TB
this is Code
#!/bin/ksh
DATE=`date '+%d%m%y'`
for f in `cat /home/esx-capacity/esx-host.txt`
do
for g in `cat /home/esx-capacity/frame`... (10 Replies)
Discussion started by: ranjancom2000
10 Replies
soelim(1) User Commands soelim(1)
NAME
soelim - resolve and eliminate .so requests from nroff or troff input
SYNOPSIS
soelim [filename...]
DESCRIPTION
soelim reads the specified files or the standard input and performs the textual inclusion implied by the nroff(1) directives of the form
.so somefile
when they appear at the beginning of input lines. This is useful since programs such as tbl(1) do not normally do this; it allows the
placement of individual tables in separate files to be run as a part of a large document.
An argument consisting of `-' is taken to be a file name corresponding to the standard input.
Note: Inclusion can be suppressed by using `'' instead of `.', that is,
' so /usr/share/lib/tmac/tmac.s
EXAMPLES
Example 1: A sample of the soelim command.
A sample usage of soelim would be
example% soelim exum?.n | tbl | nroff -ms | col | lpr
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWdoc |
+-----------------------------+-----------------------------+
SEE ALSO
more(1), nroff(1), tbl(1), attributes(5)
SunOS 5.10 14 Sep 1992 soelim(1)