I need the following websites scraped and the data in two separate spreadsheet under the following fields
First Name, Surname, Business Name, Address, Suburb, State, Post Code, Phone, Description, Website, Email. There may be multiple addresses per name and they should be recorded on a separate line.
This is the main URL [url removed, login to view] you can see on the right hand side "optometrist search" if you include 0000 in the postcode field it will generate a full list with multiple pages.
[url removed, login to view]
Using Yellow pages you will need to scrape another listing and include the same fields
[url removed, login to view]+States&selectedViewMode=&emsLocationId=
If you click on a link you can view their email details [url removed, login to view]
3. Finally you need to merge both databases and remove duplicates with same name AND address and please provide as a csv or xls file.