I have around 100 html files and in each html file I have 5-6 such paragraphs of a company and I need to extract the Name of the company from either the one after "title" or "/company" and then the number of employees and finally the location .
<div class="search_result">
<div class="search_result_name">
<a href="/company/BlahBlah" title="BlahBlah, Inc.">BlahBlah, Inc.</a>
</div>
</div>
<div class="search_result_explanation">
60 employees
</div>
<div class="search_result_explanation">
Office in
Palo Alto, CA, 94301, USA
The output I want is just 3 columns
Company Employees Location
BlahBlah 60 Palo Alto
Any ideas are appreciated