Hi there,

I have a text importing query.
Please see the text quoted below.
What I want to do (may not be possible) is end up with the following output:

A1 - TIMOCRACY
A2 - WOR ROM (IRE)
A3 - PORTSIDE (IRE)
etc..

B1 - Robert Walford, the rider of TIMOCRACY, reported that the gelding was unsuited by the good to firm ground. C34
B2 - Mr P.J. Tolman, the rider of WOR ROM (IRE) reported that the gelding hung left throughout. D49
B3 - Robert Thornton, the rider of PORTSIDE (IRE), which was pulled-up, reported that the gelding was never travelling. D49
etc..

Added bonus would be to get the Date entered into C1, C2, C3 etc.

Few problems I forsee with this are that not all the setences are on 1 line. Pasting that text into excel would return some setences over 2 lines and 2 separate cells. I would need them combined in 1 cell.


Uttoxeter, 4 October 2009

Robert Walford, the rider of TIMOCRACY, reported that the
gelding was unsuited by the good to firm ground. C34

Mr P.J. Tolman, the rider of WOR ROM (IRE) reported that the
gelding hung left throughout. D49

Robert Thornton, the rider of PORTSIDE (IRE), which was pulled-up, reported that the gelding was never travelling. D49

J.W. Farrelly, the rider of COOLDINE LAD (IRE) reported that the
gelding bled from the nose. C34

Kelso, 4 October 2009

Stewards considered the running of SIERRA PEAK (IRE) ridden by G Lee and trained by M Todhunter, who started joint favourite and pulled up and having received a report that the trainer was unable to offer any explanation and in the absence of any other relevant information, they decided not to hold an enquiry. The Stewards ordered SIERRA PEAK (IRE) to be routine tested.

T Murphy, the rider of MARCEL (FR), reported that the gelding lost its action and pulled up.

P Callaghan, the rider of SYD’S PRINCESS, reported that the filly suffered interference on the stands bend.

B Hughes, the rider of FLYING FEATHERS (IRE), reported that the mare ran too free.
Please let me know if you think this is possible and if you know how to solve the problem. I would be very grateful.

Happy to answer more questions
(original link to text: http://www.bha.org/inside_horseracin...hyranbadly.asp )

Thanks very much in advance.