racing cards and excel

[wb]

Does anyone know of any websites where you can copy and paste
a) jockeys
b) trainers
c) horse names
in a list into a spreadsheet column.?



At the moment, I re-type all of this into the columns.

Thanks

[mathare]

What about Sporting Life? They lay their cards out as shown here (http://horses.sportinglife.com/Racecards/0,12495,186939,00.html). Will that c&p successfully?

[wb]

Thanks mathare, not quite what I want though. Basically, take for example the jockey names. I need them in one list (seperate from the other info) that can be copied on its own, so this list can be pasted into a column. In most sites the info is all together, and you can't copy just the jockeys names

[lowe1]

here you go for the jockeys

http://www.adrianmassey.com/db2/dbjtf.php?flat=1&joc=1&days=7

if you go to the homepage as well tyou can get the list for NH list as well

[wb]

Thanks lowe, not really what im after.

May not have explained this properly. Basically, When analysing a race, I want to save myself re-typing all the jockeys names into my spreadsheet. most racecards dont 'list' the jockeys so that you could copy and paste the names straight into a spreadsheet.

thanks all the same

[MattR]

Depending how it pastes in you might be able to paste the whole racecard across and excel will have it in columns, it doesn't always seem to do this and I can't make any sense of when it will and won't but I have done this with things like league tables and sometimes it will put each column into a seperate column (eg Pl W D L etc) other times it tries to paste it all in one cell. I'm sure Mat will have the answer to why that is though.

[wb]

Depending how it pastes in you might be able to paste the whole racecard across and excel will have it in columns, it doesn't always seem to do this and I can't make any sense of when it will and won't but I have done this with things like league tables and sometimes it will put each column into a seperate column (eg Pl W D L etc) other times it tries to paste it all in one cell. I'm sure Mat will have the answer to why that is though.

yep, this happens me too. The Pc in college pastes them into the columns, but it does not quite work how i want it to. the pc at home justs pastes 'over' the cells

[MattR]

Wayne, have you tried pasting over the fastcards on sporting life?

[vegyjones]

If you copy and paste it into a spreadie...

Go Data -> Text To Columns -> Select delimiter

Let me know if that is any good!

Although this will probably be a bit of a mess due to some horses having 2 or 3 word names

Try it and see what you think!

[wb]

Thanks everyone, this may work yet. I will play around with it tomorrow (don't have excel at home - just the xp spreadsheet)

[MattR]

Wayne , I might have just cracked it.


I've managed to find a way so that it's all in columns and it's not all hyperlink typing.

What I did was copy the full racecard from sporting life. Then paste it into word (didn't work the same unless I did this first). Then copy the whole card again from where it's been pasted in Word. Now click a cell in your excel, now go to the edit menu and choose paste special, you should get a window come up with five options, the bottom one just says TEXT, Choose that and it pasted perfectly, no hyperlink text, no html stuff just all plain text in separate columns.

For some reason trying to paste it straight in there from sporting life it doesn't come out the same.

[MattR]

Going to attach an excel sheet so you can se what it looked like.

[MattR]

OK, here you go

[MattR]

Only pain is some numbers change to date, but I imagine setting sheet to 'text' on the cell option before pasting would sort that out.

[wb]

Can't open excel at home, but will try tomorrow at college. Have tried this on the spreadsheet that I do have at home, and looks like I may be able to find a solution using your way. Thanks for this. Have some good rep:)

[wb]

By the way, is this sporting life's quick card?

[MattR]

No, this was the full one with the jockey's colours and everything.

[wb]

managed to open your file in my spreadsheet. Yep, thats pretty much what I wanted to do! Thanks again, much appreciated.

[MattR]

Great, glad that's worked for you. Also just tested changing format of cells for sheet to 'text' before pasting and it does stop the form and some jockey weights changing to dates. They all come out correctly if you do that first.