Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

Exporting address off of a website

Hello,

My company is a Subway financing company. Is there a way to scrap the information off of this website to excel and import to ACT!

http://www.switchboard.com/bin/cgidir.dll?PR=120&ST=1&KW=Subway+&MEM=1&L=Subway+&QV=02A5BB54A83F8D4025303203O01A5B854A83F8D4027303203O07A5B954A83F8D4020303203O03A52F3DA83F8D4027303203&LNK=54:3&BW=B

Thanks for your help.
0
cbarone2004
Asked:
cbarone2004
2 Solutions
 
taherzmCommented:
Yep its certainly is possible...
But its requires that you write a custom
script that will parse the page and put all
the information u need into CSV format.
The webpage has a particular format that
u need to follow...i.e.
all addresses are inside the <table></table> tags
and address information is inside <div class="lm">...

basically u need to get all the information between these tags...

0
 
cookreCommented:
...and then look for the 'next' link to get the URL for the next page
wash, rinse, repeat
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now