Hi please advise if possible?
I have 1000 html files in a folder and each file is a refernec to a HP PC and its warranty staus. Here is an example...
| Serial number |
CZC33319XW |
| Product number |
DK907A |
| Product line |
Corporate Mainstream |
| Product description |
d530S/P2.4/40bc/256E/4 |
| Date of warranty check |
24 Oct 2008 |
| Warranty type |
Service type |
Start date |
End date |
Status |
Service level |
Deliverables |
| Base Warranty |
Wty: HP HW Maintenance Onsite Support
|
16 Aug 2003 |
14 Sep 2006 |
Expired |
Standard Material Handling, Global Coverage, NextAvail TechResource Remote, Std Office Hrs Std Office Days, NextAvail TechResource Onsite, Next Cov Day Onsite Response, Standard Parts Logistics, No Usage Limitation |
Onsite Support, Parts and Material provided, Hardware Problem Diagnosis |
Wty: HP Support for Initial Setup
|
16 Aug 2003 |
13 Dec 2003 |
Expired |
What I need if possible is the SQL code for Log parser to go through each file and pull out the details where Service Type is Maintenance Onsite Support and the data / values for the fileds
Serial Number + Product Description + Warranty Start date + Warranty End date + the Status
If you know how to achieve this please will you email me the code to h.ghelani@rbht.nhs.uk.