We need you to extract specific fields from a few thousand HTML files. We will provide the base HTML files which link to public pages with four fields that we want to extract and place in a database.
From this Page that we will provide: file:///Users/jonathanbrun/Downloads/TRI/TRI%20Report-%20EAst%20Coast/TRI%20Report%[login to view URL]
You should extract data from all the linked company names such as this page: [login to view URL]
And extract the following fields:
Parent Company
Facility Name
Address - state acronym should be parsed and placed in a separate column
Public Contact
Phone Number
Each record should be a row in a CSV file to be delivered by email. The file should shave 6 columns:
Parent Company, Facility Name, Address, State, Public Contact, Phone Number
## Deliverables
Attached file.