ALTERNATIVE SCRAPER

[BERTRAND]

I am trying to use the "Export to Excel" function to scrape the Sporting Life live prices. It works very well although the minimum refresh time is 1 minute. I am having a big problem with the horse names-as follows:-
Lady Of The House (IRE) 16 Beaten Favourite
Pippy 26
Roland 21
Dark Opal (IRE)
I just need the horse name on it's own and in a format such that VLOOKUP will work. I am aware of the functions LEFT/RIGHT/MID, but none of those does the job. Also I can't use the saddlecloth numbers because I have all the days races on the same sheet.
Can anyone help?
Bert

[negapo]

You want to remove the "(IRE)", "Beaten Favourite", and the numbers?
If you make a list of words that you want to remove i can build a function to clean the names

[osknows]

Hi Bert,

It would be quicker to extract the data using VBA and fix the horse names at source. Most of the inbuilt Excel web scraping functions are really slow and often struggle to parse the data correctly if the html is not properly formed for output to a table.

Attached is a workaround using Excel formulae only that will clean the examples you've shown. I've split it into stages which (hopefully?) makes it more easy to follow

http://www.mediafire.com/?y9c4q81z9ba4rd8

Os

[BERTRAND]

Thanks for the formulae Os. Just the job, actions explicit! I appreciate your
time.

There have been a few examples of Code to get the Sporting Life live prices, but nothing recently. Also, authors of such Code will get bombarded with requests everytime it needs updating!

Bert

[BERTRAND]

Thanks for your offer Negapo
Bert

[negapo]

Your welcome