Scrape website for Zip Codes

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.

Beceriler: C++ Programlama, PHP, Kabuk Betiği, Visual Basic, Web Scraping

Daha fazlasını gör: html spreadsheet example, example of a job letter, example letter job, convert excel to website, scrape website, scrape html, codes, zip city state, zip code city excel, php convert html excel, 2013 excel visual basic, city zip, city state zip codes, excel 2013 visual, website pattern, pattern website, convert php html excel, excel visual basic website data, excel convert html, scrape code

İşveren Hakkında:
( 60 değerlendirme ) olympia, United States

Proje NO: #4592255



Sent you a detailed PM.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)

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.

in %bids___i_period_sub_35% gün içinde139%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(86 Değerlendirme)

Can do this. See PM Box.

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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

in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

it will be pleasure to work with you.

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

We are specialized in data extraction. please check your inbox.

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)