linux - How to add numbers in a column and insert the total to a differentcolumn -

-

let me preface saying i'm complete newbie scripting.

we have many mismanaged quota files need totals updated. i'd have script can calculate totals of each volume instead of doing mechanically every month. please see example below.

our quota file looks this:

/vol/vol1/nstorage1             tree    200g /vol/vol1/nstorage2             tree    5g  /vol/vol1/nstorage3             tree    300g /vol/vol1/nstorage4             tree    145g /vol/vol1/nstorage5             tree    3g /vol/vol1/nstorage6             tree    5g # # vol1 total 700gb  /vol/vol2/nstorage7             tree    20g /vol/vol2/nstorage8             tree    1g /vol/vol2/nstorage9             tree    30g /vol/vol2/nstorage10            tree    55g /vol/vol2/nstorage11            tree    25g /vol/vol2/nstorage12            tree    430g /vol/vol2/nstorage13            tree    20g # # vol2 total 550gb

and on....

what trying take total sum 3rd column, , add "volx total ####gb" line.

i have tried use awk first section of column , don't know how replace total each column. 

awk '{ sum += $3 } end { print sum }' < file

any appreciated.

if unit in file gb, can use line:

awk '!/^#/{s+=$3+0;print;next}nf>1{$nf=$nf+s"gb";s=0}7' file

with input example, output:

/vol/vol1/nstorage1             tree    200g /vol/vol1/nstorage2             tree    5g  /vol/vol1/nstorage3             tree    300g /vol/vol1/nstorage4             tree    145g /vol/vol1/nstorage5             tree    3g /vol/vol1/nstorage6             tree    5g # # vol1 total 1358gb  /vol/vol2/nstorage7             tree    20g /vol/vol2/nstorage8             tree    1g /vol/vol2/nstorage9             tree    30g /vol/vol2/nstorage10            tree    55g /vol/vol2/nstorage11            tree    25g /vol/vol2/nstorage12            tree    430g /vol/vol2/nstorage13            tree    20g # # vol2 total 1131gb

update

if want sum replace total value, not add to, just:

 awk '!/^#/{s+=$3+0;print;next}nf>1{$nf=s"gb";s=0}7' file

Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more