where to get U.s university and college list or other info

Hi
I was wondering if anyone knows a good place for downloading or purchasing data such as complete US university or college list for importing to mysql or a complete list of restaurants and locations and so on....


Thanks,
Raz
ucsdmbdmAsked:
Who is Participating?
 
mankowitzConnect With a Mentor Commented:
Well, each line is of the format:

            <LI><A HREF="http://www.ycp.edu/" TARGET="_blank">York College of Pennsylvania</A> (PA)</LI>

so do this:

0. go to the web page and save the source code
1. open mysql query browser and create a table for name and url
2. open Tools->Regex text importer
3. Enter the following regex
<LI><A href="(http[^"]*)" target="_blank">(.*?)</LI>
4. Click the load source button and import the file you saved in step 0
5. go to the "trigger insert statement and put something like this:
INSERT INTO foo (url, university) VALUES ('$u.1', '$u.2');
6. go to the name of the regex (default is RegEx) and hit F2, rename it to "u"
7. click "execute regex"
8. click "preview"

You will end up with something like the attached file
univ.sql
0
 
mankowitzCommented:
University of texas has a nice list for free: http://www.utexas.edu/world/univ/alpha/
For other industries, there are lots of sites that sell sales leads, for example: http://www.goleads.com/
0
 
ucsdmbdmAuthor Commented:
Hi

Thanks for the reply.

Do you know how can I export the list into excel or mysql ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.