This is my very first post. I have a network appliance that sends me daily reports in html format. The goal is to input this daily data in an xl spreadsheet.
The format looks like this.
Daily Incoming Report : 01/01/2003
Totals and Averages:
Total Message Count 87140
Total Message Count (Encrypted/Signed) 10
Total Messages (with SSL) 1498
Total Messages (without SSL) 85642
Total Message Volume (MB) 1441.18
Average Messages per Hour 3630.83
Average Volume per Hour (MB) 60.05
So far I have discovered two choices.
1, use lynx -dump html_file.html > text_file.txt which strips all the html tags, I then use sed to pull the lines I am interested in.
The dilema is to imprt those lines and files into xl.
2, I looked here and found this, but am not sure how to use it.
Any help will be greatly appreciated.