[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

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
0
ucsdmbdm
Asked:
ucsdmbdm
  • 2
1 Solution
 
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
 
mankowitzCommented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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