Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help with AWK math
Top Forums Shell Programming and Scripting Need help with AWK math Post 302630841 by brianjb on Thursday 26th of April 2012 10:47:31 AM
Old 04-26-2012
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):

Code:
[@ns1 ~]$ tail -n 6 named.stats | awk -F\, '{print$1}'
1141804
1140566
1139429
1134210
1084682
895045
[@ns1 ~]$ tail -n 6 named.stats | awk -F\, '{print$1}' | awk '{ sum+=$1} END {print sum/6}'
1.08929e+06

But if I calculate smaller numbers:
Code:
[@ns1 ~]$ tail -n 6 named.stats | awk -F\, '{print$1}'
2
3452
459
7772
442
10
[@ns1 ~]$ tail -n 6 named.stats | awk -F\, '{print$1}' | awk '{ sum+=$1} END {print sum/6}'
2022.83

Any suggestions? Will it work like that?

Here is how I am comparing:

Code:
MAX=`echo 700000`
LASTINV=`tail -n 1 $QLOG | awk -F\, '{print $1}'`
LASTHOUR=`tail -n 6 $QLOG | awk -F\, '{print $1}' | awk '{ sum+=$1} END {print sum/6}'`

CHANGE=`echo "$LASTINV $LASTHOUR" | awk '{if (($1/$2) > 5) {print "EXCEED";} else {print "NOMINAL";}}'`
      if [ "$CHANGE" = "EXCEED" ]
      then

Here is what the variables look like, for example:

Code:
[@ns1 ~]$ tail -n 1 named.stats
10,24-Apr-2012,19:50

LASTINV:
[@ns1 ~]$ tail -n 1 named.stats | awk -F\, '{print $1}'
10

[@ns1 ~]$ tail -n 6 named.stats
1141804,24-Apr-2012,19:00
1140566,24-Apr-2012,19:10
1139429,24-Apr-2012,19:20
1134210,24-Apr-2012,19:30
1084682,24-Apr-2012,19:40
895045,24-Apr-2012,19:50


I hope I have given you enough to help me.

I appreciate your help!
 

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

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

4. 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

5. 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

6. 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

7. Shell Programming and Scripting

awk --> math-operation in data-record and joining with second file data

Hi! I have a pretty complex job - at least for me! i have two csv-files with meassurement-data: fileA ...... (2 Replies)
Discussion started by: IMPe
2 Replies

8. Shell Programming and Scripting

Count math using awk

Hi expert, I have log : TOTAL-TIME : 2125264636 DATA-BYTES-DOWN : 3766111307032 DATA-BYTES-UP : 455032157567 DL = (3766111307032/2125264636)/1024 = 1.73 UL = (455032157567/2125264636)/1024 = 0.21 I want the result : TOTAL = 1.94 ... (4 Replies)
Discussion started by: justbow
4 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 REDHAT

tail

TAIL(1) 								FSF								   TAIL(1)

NAME

       tail - output the last part of files

SYNOPSIS

       tail [OPTION]... [FILE]...

DESCRIPTION

       Print  the  last 10 lines of each FILE to standard output.  With more than one FILE, precede each with a header giving the file name.  With
       no FILE, or when FILE is -, read standard input.

       Mandatory arguments to long options are mandatory for short options too.

       --retry
	      keep trying to open a file even if it is inaccessible when tail starts or if it becomes inaccessible later -- useful only with -f

       -c, --bytes=N
	      output the last N bytes

       -f, --follow[={name|descriptor}]
	      output appended data as the file grows; -f, --follow, and --follow=descriptor are equivalent

       -F     same as --follow=name --retry

       -n, --lines=N
	      output the last N lines, instead of the last 10

       --max-unchanged-stats=N
	      with --follow=name, reopen a FILE which has not changed size after N (default 5) iterations to  see  if  it  has	been  unlinked	or
	      renamed (this is the usual case of rotated log files)

       --pid=PID
	      with -f, terminate after process ID, PID dies

       -q, --quiet, --silent
	      never output headers giving file names

       -s, --sleep-interval=S
	      with -f, sleep for approximately S seconds (default 1.0) between iterations.

       -v, --verbose
	      always output headers giving file names

       --help display this help and exit

       --version
	      output version information and exit

       If  the first character of N (the number of bytes or lines) is a `+', print beginning with the Nth item from the start of each file, other-
       wise, print the last N items in the file.  N may have a multiplier suffix: b for 512, k for 1024, m for 1048576 (1 Meg).

       With --follow (-f), tail defaults to following the file descriptor, which means that even if a tail'ed file is renamed, tail will  continue
       to  track its end.  This default behavior is not desirable when you really want to track the actual name of the file, not the file descrip-
       tor (e.g., log rotation).  Use --follow=name in that case.  That causes tail to track the named file by reopening it periodically to see if
       it has been removed and recreated by some other program.

AUTHOR

       Written by Paul Rubin, David MacKenzie, Ian Lance Taylor, and Jim Meyering.

REPORTING BUGS

       Report bugs to <bug-coreutils@gnu.org>.

COPYRIGHT

       Copyright (C) 2002 Free Software Foundation, Inc.
       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

SEE ALSO

       The full documentation for tail is maintained as a Texinfo manual.  If the info and tail programs are properly installed at your site,  the
       command

	      info tail

       should give you access to the complete manual.

tail (coreutils) 4.5.3						   February 2003							   TAIL(1)
All times are GMT -4. The time now is 07:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy