I have an excel file that I need scraped against a URL given a specific pattern in order to obtain zip codes.
THe URL to scrape is: [url removed, login to view](CITY)-(STATE).html
My excel spreadsheet has the city and states...HOWEVER my states are abbreviated and you must convert the abbbreviations to full states for the URL
The Excel spreadsheet has 2 columns...your job is to make a third column and dump in the ZIP CODE which is obtained in the TITLE of each scraped URL
For any URL that does not scrape, leave the ZIP column blank in the spreadsheet.
Excel Spreadsheet has
French Island WI
So you go to URL:
[url removed, login to view]
And you SCRAPE the ZIP CODE 54603.
You put 54603 in the third column of the spreadsheet and move to the next. Nice and easy.
Remember you must convert all the 2 letter State abbreviations to full states.
Also...substitute all SPACES for DASHES in your URL
Sometimes a ZIP might not be in the URL or you might get a page not found...move on to the next one.
Bu iş için 6 freelancer ortalamada $173 teklif veriyor
i am a C++ Programming, PHP, Shell Script, Visual Basic, Web Scraping expert. pls tell me your job details. then i will work for u immediately. Thx.
Hello, We have Experienced Professionals with 3 years of Web Development & Designing, Application Development, Desktop Application, ERP Software, Android App. Development. I-phone Development expertise. We have worked Daha Fazla
We are specialized in data extraction. please check your inbox.