Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Count math using awk
Top Forums Shell Programming and Scripting Count math using awk Post 302928257 by RavinderSingh13 on Wednesday 10th of December 2014 09:26:55 AM
Old 12-10-2014
Quote:
Originally Posted by junior-helper
Also try
Code:
awk -F':' '$1 ~ /TIME/ { t=$2 } $1 ~ /DOWN/ { d=$2 } $1 ~ /UP/ { u=$2 }
            END { a=d/t/1024; b=u/t/1024; printf "%s %2.2f\n", "TOTAL =", a+b }' log

Hello junior-helper,

If input file has more than one set of entries provided by user then above command will give only the last line value. Let's say following is the input file.

Code:
TOTAL-TIME                :      2125264636
DATA-BYTES-DOWN           :   3766111307032
DATA-BYTES-UP             :    455032157567
TOTAL-TIME                :      2128964636
DATA-BYTES-DOWN           :   376616327207032
DATA-BYTES-UP             :    455032123672567
TOTAL-TIME                :      21252647866
DATA-BYTES-DOWN           :   3766111307278387232
DATA-BYTES-UP             :    455032152376267
TOTAL-TIME                :      21252127236
DATA-BYTES-DOWN           :   376611113131032
DATA-BYTES-UP             :    4550321131313167

Then it will give output as follows.
Code:
awk -F':' '$1 ~ /TIME/ { t=$2 } $1 ~ /DOWN/ { d=$2 } $1 ~ /UP/ { u=$2 }
 END { a=d/t/1024; b=u/t/1024; printf "%s %2.2f\n", "TOTAL =", a+b }' Input_file
TOTAL = 226.40

So we can use following for it.
Code:
awk -F':' '$1 ~ /TIME/ { t=$2 } $1 ~ /DOWN/ { d=$2 } $1 ~ /UP/ { u=$2; a=d/t/1024; b=u/t/1024; printf "%s %2.2f\n", "TOTAL =", a+b;next }'  Input_file

Output will be as follows now.
Code:
TOTAL = 1.94
TOTAL = 381.48
TOTAL = 173074.31
TOTAL = 226.40

Thanks,
R. Singh
Last edited by RavinderSingh13; 12-10-2014 at 10:29 AM.. Reason: Added output at last
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk logic and math help

Hi, My file has 2 fields and millions of lines. variableStep chrom=Uextra span=25 201 0.5952 226 0.330693 251 0.121004 276 0.0736858 301 0.0646982 326 0.0736858 401 0.2952 426 0.230693 451 0.221004 476 0.2736858 Each field either has a... (6 Replies)
Discussion started by: wyarosh
6 Replies

2. Shell Programming and Scripting

awk math operation on two files

Hi, I need your help. I've got two files and i need to add 2nd line after occurrence of "Group No X" from data2.txt to 3rd line (after occurrence of "Group No X") from data1.txt. There is the same number of "Groups" in both files and the numbers of groups have the same pattern. data1.txt Group... (2 Replies)
Discussion started by: killerbee
2 Replies

3. Shell Programming and Scripting

Need help with AWK math

I am trying to do some math, so that I can compare the average of six numbers to a variable. Here is what it looks like (note that when I divide really big numbers, it isn't a real number): $ tail -n 6 named.stats | awk -F\, '{print$1}' 1141804 1140566 1139429 1134210 1084682 895045... (3 Replies)
Discussion started by: brianjb
3 Replies

4. Shell Programming and Scripting

awk math and csv output

Hi I have this list 592;1;Z:\WB\DOCS;/FS3_100G/FILER112/BU/MPS/DOCS;;;;\\FILER112\BUMPS-DOCS\;580,116,544,878 Bytes;656,561 ;77,560 592;2;Z:\WB\FOCUS;/FS3_100G/FILER112/BU/MPS/FOCUS;;;;\\FILER112\BUMPS-FOCUS\;172,430 Bytes;6 ;0 ... (12 Replies)
Discussion started by: nakaedu
12 Replies

5. Shell Programming and Scripting

awk - count character count of fields

Hello All, I got a requirement when I was working with a file. Say the file has unloads of data from a table in the form 1|121|asda|434|thesi|2012|05|24| 1|343|unit|09|best|2012|11|5| I was put into a scenario where I need the field count in all the lines in that file. It was simply... (6 Replies)
Discussion started by: PikK45
6 Replies

6. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

7. Shell Programming and Scripting

awk evaluating a string as a math expression

Hi, I am writing a script in awk trying to replace strings that are math expressions with their result. For example, I have a file that looks like this: 5-1 32/8-1 4*12 17+1-3 I would like to get the following output: 4 3 48 15 I tried doing it the following way (using the "bc"... (8 Replies)
Discussion started by: avi.levi
8 Replies

8. Shell Programming and Scripting

awk --> math-operation in a array

Hi main object is categorize the difference of data-values (TLUFT02B - TLUFT12B). herefor i read out data-files which are named acording to the timeformat yyyymmddhhmm. WR030B 266.48 Grad 0 WR050B 271.46 Grad 0 WR120B 268.11 Grad 0 WV030B 2.51 m/s ... (6 Replies)
Discussion started by: IMPe
6 Replies

9. Shell Programming and Scripting

Math count %memory using awk

Hi expert, i have log this: Memory: 74410384 Memory: 75831176 Memory: 77961232 Memory: 77074656 Memory: 76086160 Memory: 77128592 Memory: 78045384 Memory: 76696040 Memory: 72401176 Memory: 72520016 Memory: 72137016 Memory: 73175832 Memory: 73034528 Memory: 71770736 Memory:... (4 Replies)
Discussion started by: justbow
4 Replies

10. Shell Programming and Scripting

[awk] Math & Bold-Font?

Heya There is a script which has presets stored in a tab-seperated file. That script also has $help_text, which will be shown when called with invalid arguments or -h. So i do need to have that file ready, so the help text can get the values out of the file, and print it with the $help_text.... (17 Replies)
Discussion started by: sea
17 Replies

LEARN ABOUT OSX

vfs_cacheprime

VFS_CACHEPRIME(8)														 VFS_CACHEPRIME(8)

NAME

       vfs_cacheprime - prime the kernel file data cache

SYNOPSIS

       vfs objects = cacheprime

DESCRIPTION

       This VFS module is part of the samba(7) suite.

       The  vfs_cacheprime  VFS  module reads chunks of file data near the range requested by clients in order to make sure the data is present in
       the kernel file data cache at the time when it is actually requested by clients.

       The size of the disk read operations performed by vfs_cacheprime is determined by the cacheprime:rsize option. All disk read operations are
       aligned	on  boundaries that are a multiple of this size. Each range of the file data is primed at most once during the time the client has
       the file open.

       This module is stackable.

OPTIONS

       cacheprime:rsize = BYTES
	  The number of bytes with which to prime the kernel data cache.

	  The following suffixes may be applied to BYTES:

	     o	K - BYTES is a number of kilobytes

	     o	M - BYTES is a number of megabytes

	     o	G - BYTES is a number of gigabytes

EXAMPLES

       For a hypothetical disk array, it is necessary to ensure that all read operations are of size 1 megabyte (1048576 bytes), and aligned on  1
       megabyte boundaries:

	    [hypothetical]
	    vfs objects = cacheprime
	    cacheprime:rsize = 1M

CAVEATS

       cacheprime is not a a substitute for a general-purpose readahead mechanism. It is intended for use only in very specific environments where
       disk operations must be aligned and sized to known values (as much as that is possible).

VERSION

       This man page is correct for version 3.0.25 of the Samba suite.

AUTHOR

       The original Samba software and related utilities were created by Andrew Tridgell. Samba is now developed by the  Samba	Team  as  an  Open
       Source project similar to the way the Linux kernel is developed.

																 VFS_CACHEPRIME(8)
All times are GMT -4. The time now is 01:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy