We need to extract data from [url removed, login to view] category search results. 50 records are displayed at a time. The script needs to capture the following fields from each company record and provide the data as a record (with fields being displayed in each column) in an excel file.
The following field data needs to be extracted:
1. Company Name
2. Address with city, state & country being extracted in different columns
3. Phone No.
4. Cell No
5. URL/website address
6. small write-up about the company and its products (three lines given in search results)