Solved

Exporting address off of a website

Posted on 2004-04-20
4
204 Views
Last Modified: 2010-05-18
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
Comment
Question by:cbarone2004
4 Comments
 
LVL 2

Accepted Solution

by:
taherzm earned 250 total points
ID: 10869405
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
 
LVL 22

Assisted Solution

by:cookre
cookre earned 250 total points
ID: 10873018
...and then look for the 'next' link to get the URL for the next page
wash, rinse, repeat
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now