I need to grab the name(s)/address(es) from this dB: http://www.medilexicon.com/pharmaceuticalcompanies.php Search for USA There are 978 Results. I want this in excel with the fields: name/street/city/state/zip
I've done it before using tidy and php xslt. You can scrape the elements that contain addresses and write them to a new file. You'll have to create a list for all the countries and loop this link. ...pharmaceuticalcompanies.php?pharmacountry=USA