Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Math count %memory using awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Math count %memory using awk
# 1  
Old 01-02-2015
Math count %memory using awk
Hi expert,

i have log this:

Code:
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: 70629968
Memory: 1201871408
Memory: 1200533688
Memory: 1204072584
Memory: 1207242520
Memory: 1189510880
Memory: 1194879552
Memory: 1184069360
Memory: 1205724952
Memory: 1207634864
Memory: 1199368248
Memory: 1196559296
Memory: 1191823312
Memory: 1202758160
Memory: 1198021912
Memory: 1205363264


I want to count % memory with 2 digit after comma.

I try this but doesn't work

Code:
awk '{print $2/1024/1024/9787*100}' | bc | sed -re 's/([0-9]+\.[0-9]{2})[0-9]+/\1/g'

The results should be like this:
Code:
0.72
0.73
0.75
0.75
0.74
0.75
0.76
0.74
0.70
0.70
0.70
0.71
0.71
0.69
0.68
11.71
11.69
11.73
11.76
11.59
11.64
11.53
11.74
11.76
11.68
11.65
11.61
11.72
11.67
11.74

Thanks
Last edited by justbow; 01-02-2015 at 10:53 PM.. Reason: change
# 2  
Old 01-02-2015
expert,
Now that we see what 'you log' looks like, what your expert wants to see as output?
# 3  
Old 01-02-2015
the output should be as above.
# 4  
Old 01-02-2015
printf("%.2f\n", $3/1024/.....)

---------- Post updated at 10:07 PM ---------- Previous update was at 10:05 PM ----------

Quote:
Originally Posted by justbow
Hi expert,

i have log this:

Code:
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: 70629968
Memory: 1201871408
Memory: 1200533688
Memory: 1204072584
Memory: 1207242520
Memory: 1189510880
Memory: 1194879552
Memory: 1184069360
Memory: 1205724952
Memory: 1207634864
Memory: 1199368248
Memory: 1196559296
Memory: 1191823312
Memory: 1202758160
Memory: 1198021912
Memory: 1205363264


I want to count % memory with 2 digit after comma.

I try this but doesn't work

Code:
awk '{print $2/1024/1024/9787*100}' | bc | sed -re 's/([0-9]+\.[0-9]{2})[0-9]+/\1/g'

The results should be like this:
Code:
0.72
0.73
0.75
0.75
0.74
0.75
0.76
0.74
0.70
0.70
0.70
0.71
0.71
0.69
0.68
11.71
11.69
11.73
11.76
11.59
11.64
11.53
11.74
11.76
11.68
11.65
11.61
11.72
11.67
11.74

Thanks

Quote:
Originally Posted by vgersh99
printf("%.2f\n", $3/1024/.....)
No bc, no sed - just awk
This User Gave Thanks to vgersh99 For This Post:
justbow
# 5  
Old 01-03-2015
For highest precision do the mult before the div
Code:
$2*100/1024/1024/9787

or force to floating-point
Code:
$2/1024.0/1024/9787*100

This User Gave Thanks to MadeInGermany For This Post:
justbow
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
Login or Register to Ask a Question