Here is a link to a list of college names and their .edu email http://pastebin.com/LND21t5F
I want to take those lines of code and put the .edu part into one coloumn of a database and the name of the college into another coloumn.
My database is structure like this (id, college_email, college_name)
Can some one help me do this?