Shell Programming and Scripting

vnstat -i eth0 -d

 eth0  /  daily

         day         rx      |     tx      |    total    |   avg. rate
     ------------------------+-------------+-------------+---------------
     08/11/2015     1.83 MiB |    2.31 MiB |    4.15 MiB |    0.39 kbit/s
     08/12/2015    12.35 MiB |   15.40 MiB |   27.75 MiB |    2.63 kbit/s
     08/13/2015    16.31 MiB |   18.36 MiB |   34.67 MiB |    3.29 kbit/s
     08/14/2015    11.45 MiB |   15.11 MiB |   26.56 MiB |    2.52 kbit/s
     08/15/2015    38.65 MiB |   87.17 MiB |  125.81 MiB |   11.93 kbit/s
     08/16/2015    12.08 MiB |   15.76 MiB |   27.84 MiB |    2.64 kbit/s
     08/17/2015    29.86 MiB |   40.78 MiB |   70.65 MiB |    6.70 kbit/s
     08/18/2015    43.67 MiB |   58.62 MiB |  102.29 MiB |    9.70 kbit/s
     08/19/2015    27.08 MiB |   42.74 MiB |   69.82 MiB |    6.62 kbit/s
     08/20/2015      300 KiB |     298 KiB |     598 KiB |    0.14 kbit/s
     ------------------------+-------------+-------------+---------------
     estimated        --     |      --     |      --     |

#!/bin/bash

# change directory
cd /var/log/netlogs/

for logFile in *_net.log
do
  awk '
    BEGIN ( OFS = "," ) FNR == 1 {
      # get date, hostname, interface
      split(FILENAME,F,/_/)
      d=F[1]
      h=F[2]
      i=F[3]
    }
    # Output Format
    # date,hostname,interface,rx,tx,tot,avg
    {
      print d,h,i 
    }
  ' $logfile > /var/log/netlogs/$logfile.csv
done