I get a daily email which is a report of bandwidth usage and I need to extract that data and put it in Excel for reporting.
To date there are over 400 messages I would like to process.
A typical day's email looks like:
: customer_Name_Goes _Here : Vlan999 customer_Name_Goes _Here $$ bw=45
---------------------------------------
| MONTH(5 minute avg) -- 95% : 9115.09kb/sec Max: 46430.21kb/sec
| MONTH(2 hour avg ) -- Avg In: 4080.0kb/s(0.4%) Avg Out: 1651.7kb/s(0.2%)
| DAY(5 minute avg) -- Avg In: 3715.2kb/s(0.4%) Avg Out: 1773.3kb/s(0.2%)
---------------------------------------
Additionally I need to get the "Sent" date.
Then parse this into CSV or straight into Excel go to the next message and repeat until I get all the data in one file.
In CSV it should be:
Sent,MONTH5mAvg95,MONTH5mAvgMax,MONTH2hAvgIn,MONTH2hAvgOut,DAY5mAvgIn,DAY5mAvgOut
5/22/2014,9115.09,46430.21,4080.0,1651.7,3715.2,1773.3
I have dabbled in VBA, (ok I've copied a lot ofcode from others and adapted for my own purposes), and tried searching for a solution but everything I have found on this is for extracting email addresses not just plain text. I must be looking in the wrong place.
Anyway, if you can get pointed in the right direction, it would be greatly appreciated.
David G.