Stripping Information from the Web

[AndrewKent]

Hi folks,

I wonder if anyone could help me. I am looking at this webpage:

http://www.sportinglife.com/football/live/latestscores/

And on this there are a series of Match Day Live links. Looking at the source code they all look like this:

http://www.sportinglife.com/football/live_match/203167.html

Obviously from this the "203167" will change but I wanted to extract all the codes on this page and place them in cells. is this possible?

Andy

 

[AndrewKent]

Still looking for an answer on this one. Anyone know how to scrape URLs from a webpage or its source data?

 

[Norie]

Andy

I can't find that link, or similar links on the page.

The links for Match Day Live seem to all be for pop-ups.

They do seem to contain the address for the pop-up, so it could be possible to extract that.

Of course, that would only be relevant if it's what you actually want.

 

[AndrewKent]

That is indeed what I want.

I'm looking to compile a list on an excel spreadsheet of all the Match Day Live Addresses.

Kind regards,

Andy

 

[Norie]

AndyThey aren't really links in the usual sense so to get the URL that's being passed to the javascript function you'll need to parse it out.If you were to automate IE and navigate to the page you could get all the links on.Then you would need to go through them all, somehow identify the ones of interest and then parse the URL out.By the way are you going to go on to get data from the popups?

 

[AndrewKent]

Essentially yes, my end goal is to get the data from each pop-up. The only other way I can think of doing this is to scrape the data from the source code of the page?

 

[Norie]

AndrewScrape what data from which page?You've not actually mentioned what data you want to get, and there's a fair bit of it.