12-14-2010
I am going to try and be a bit clearer. I use the following code to display the total of all fields in a column - $(awk '{s+=$3}END {print "T, "s}'. This prints "T, Total"
Sample file:
C, 818128, 5612.13122010,,,,
C, 818129, 1598.13122010,,,,
C, 818130, 7896.13122010,,,,
C, 818131, 2655.13122010,,,,
T, 1776
I am hoping it displays 17761...can anyone explain why it doesnt?
---------- Post updated at 08:28 AM ---------- Previous update was at 05:59 AM ----------
Got it sorted...
It was down to decimal points which I have been removing, for some reason when i removed the decimal point it removed the final digit.
Reorganisation and step by step breakdown solved this problem - many thanks
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have this script:
#!/bin/ksh
######### Environment Setup #########
PATH=/gers/nurev/menu/pub/sbin:/gers/nurev/menu/pub/bin:/gers/nurev/menu/pub/mac
:/gers/nurev/menu/adm/sbin:/gers/nurev/menu/adm/bin:/gers/nurev/menu/adm/mac:/ge... (5 Replies)
Discussion started by: heprox
5 Replies
2. Shell Programming and Scripting
Hello,
With the following small script I list the size of documents belonging to a certain user by each time selecting the bytes-field of that file ($7). Now it fills the array with every file it finds so in the end the output of some users contains up to 200.000 numbers. So how can I calculate... (7 Replies)
Discussion started by: Hille
7 Replies
3. Shell Programming and Scripting
awk '
FILENAME == "all" { balance += substr($0,17,13)
dt = substr($0,6,8) }
END { for ( name in balance )
printf("%013s %3s of %8s\n", balance/100,name,dt) | "sort "
} ' all > summation
using this code i wanted to take summary totals of... (3 Replies)
Discussion started by: paresh n doshi
3 Replies
4. Shell Programming and Scripting
Hi Eveyone,
I am working on one shell script to find the specific records from data file and add the totals into variables and print them. you can find the sample data file below for more clarification.
Sample Data File:
PXSTYL00__20090803USA
CHCART00__20090803IND... (7 Replies)
Discussion started by: veeru
7 Replies
5. Shell Programming and Scripting
Hello,
I have written a script in a previous server and its being migrated to a new server. I'm trying to debug my script since i've had to make minor changes to it to get it to work.
I'm having a hard time getting my totals to populate
here is the syntax
DUMP_COUNT=`sqlplus -S... (4 Replies)
Discussion started by: senormarquez
4 Replies
6. Shell Programming and Scripting
I have two files, uploads.txt and downloads.txt. I would like to combine the columns of these files based on the ip address. How can I best do this?
Uploads.txt
192.168.0.147 1565369
192.168.0.13 1664855
192.168.0.6 1332868
Downloads.txt
192.168.0.147 9838820
192.168.0.18 12051718... (7 Replies)
Discussion started by: zanyspydude
7 Replies
7. Shell Programming and Scripting
I have a one-liner script like this that gives a total of everything in various directories:
for i in *;
do (cd $i && cd statelist && echo $i && ls -la |awk 'NR>3 {SUM += $5}\
END { print "Total number of elements " SUM }');done
It works just great but at the end I want to print a grand... (3 Replies)
Discussion started by: newbie2010
3 Replies
8. UNIX for Beginners Questions & Answers
Hi all
When I sftp to an Oracle cloud server, to a folder where there are more than 10k files, and list a small subset of files, it works OK. When I try list more than 10k files, it says file not found. Example output below.
(FYI ls/mget with 6k files works OK on this server)
Has anyone... (3 Replies)
Discussion started by: pdinsdale
3 Replies
9. Shell Programming and Scripting
The OS version is
Red Hat Enterprise Linux Server release 6.10
I have a script to mask some columns with **** in a data file which is delimeted with Ç ,
I am using awk for the masking , when I try to mask a small file the awk works fine and masks the required column ,
but when the file is... (6 Replies)
Discussion started by: LinuxUser8092
6 Replies
OD(1) User Commands OD(1)
NAME
od - dump files in octal and other formats
SYNOPSIS
od [OPTION]... [FILE]...
od [-abcdfilosx]... [FILE] [[+]OFFSET[.][b]]
od --traditional [OPTION]... [FILE] [[+]OFFSET[.][b] [+][LABEL][.][b]]
DESCRIPTION
Write an unambiguous representation, octal bytes by default, of FILE to standard output. With more than one FILE argument, concatenate
them in the listed order to form the input. With no FILE, or when FILE is -, read standard input.
All arguments to long options are mandatory for short options.
-A, --address-radix=RADIX
decide how file offsets are printed
-j, --skip-bytes=BYTES
skip BYTES input bytes first
-N, --read-bytes=BYTES
limit dump to BYTES input bytes
-S, --strings[=BYTES]
output strings of at least BYTES graphic chars
-t, --format=TYPE
select output format or formats
-v, --output-duplicates
do not use * to mark line suppression
-w, --width[=BYTES]
output BYTES bytes per output line
--traditional
accept arguments in traditional form
--help display this help and exit
--version
output version information and exit
Traditional format specifications may be intermixed; they accumulate:
-a same as -t a, select named characters, ignoring high-order bit
-b same as -t o1, select octal bytes
-c same as -t c, select ASCII characters or backslash escapes
-d same as -t u2, select unsigned decimal 2-byte units
-f same as -t fF, select floats
-i same as -t dI, select decimal ints
-l same as -t dL, select decimal longs
-o same as -t o2, select octal 2-byte units
-s same as -t d2, select decimal 2-byte units
-x same as -t x2, select hexadecimal 2-byte units
If first and second call formats both apply, the second format is assumed if the last operand begins with + or (if there are 2 operands) a
digit. An OFFSET operand means -j OFFSET. LABEL is the pseudo-address at first byte printed, incremented when dump is progressing. For
OFFSET and LABEL, a 0x or 0X prefix indicates hexadecimal; suffixes may be . for octal and b for multiply by 512.
TYPE is made up of one or more of these specifications:
a named character, ignoring high-order bit
c ASCII character or backslash escape
d[SIZE]
signed decimal, SIZE bytes per integer
f[SIZE]
floating point, SIZE bytes per integer
o[SIZE]
octal, SIZE bytes per integer
u[SIZE]
unsigned decimal, SIZE bytes per integer
x[SIZE]
hexadecimal, SIZE bytes per integer
SIZE is a number. For TYPE in doux, SIZE may also be C for sizeof(char), S for sizeof(short), I for sizeof(int) or L for sizeof(long). If
TYPE is f, SIZE may also be F for sizeof(float), D for sizeof(double) or L for sizeof(long double).
RADIX is d for decimal, o for octal, x for hexadecimal or n for none. BYTES is hexadecimal with 0x or 0X prefix, and may have a multiplier
suffix: b 512, kB 1000, K 1024, MB 1000*1000, M 1024*1024, GB 1000*1000*1000, G 1024*1024*1024, and so on for T, P, E, Z, Y. Adding a z
suffix to any type displays printable characters at the end of each output line. Option --string without a number implies 3; option
--width without a number implies 32. By default, od uses -A o -t oS -w16.
AUTHOR
Written by Jim Meyering.
REPORTING BUGS
Report od bugs to bug-coreutils@gnu.org
GNU coreutils home page: <http://www.gnu.org/software/coreutils/>
General help using GNU software: <http://www.gnu.org/gethelp/>
COPYRIGHT
Copyright (C) 2009 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
The full documentation for od is maintained as a Texinfo manual. If the info and od programs are properly installed at your site, the com-
mand
info coreutils 'od invocation'
should give you access to the complete manual.
GNU coreutils 7.1 July 2010 OD(1)