I have a news site which provides daily RSS feeds (around 15 feeds a day). What I am looking for is a script that will parse the RSS News and store the following in a mysql table:
1. Date & Time of the RSS News
2. News Title
3. News Hyper Link
4. Parse and store words that begin with a capital letter. However it must be a smart parser so that the following are taken into account:
Here is a sample part of the rss text. Here are the words that the script should parse and store in database.
Officials in Memphis, Tennessee, are bracing for the Mississippi River to crest Tuesday at its highest level in more than 70 years.
The river is expected to reach 48 feet -- just shy of the 48.7-foot record set in 1937 -- shortly after midnight Tuesday, National Weather Service meteorologist Bill Borghoff told CNN Sunday.
By daybreak Sunday, the Mississippi had already reached 47.3 feet.
Local officials have a "high level of confidence" that the prediction is accurate, said Bob Nations, director of preparedness in Shelby County, Tennessee.
Residents in 1,100 trailers and homes in low-lying areas in the county, which includes Memphis and surrounding areas, have already been told to evacuate. As of Saturday, 367 residents had moved into shelters, Borghoff said.
Expected Keywords Parsed & Stored:
Officials in Memphis
National Weather Service
Note: it should have a ignore word list so that words that I choose should not be matched.
Any help is appreciated.