info needed

[system]

hi can anyone help me i need to download form guides to my comp and it cant be in html format i have only found 1 site that i can do this but it is very costly.
cheers.

[Chrome Prince]

Using excel it's quite easy to convert the html to text.

Why don't you want it in html form?

I might be able to help with more info.

Cheers.



Cha ching - this was post number 777.

Do I win the jackpot

[shoto]

You can use Ctrl-A to select all the text on the page and Ctrl-C to copy.
In Excel use Paste Special to get the option to paste as HTML or as text.
Firefox browser tends to keep the columns and layout together better than IE.

[Chrome Prince]

You can use Ctrl-A to select all the text on the page and Ctrl-C to copy.
In Excel use Paste Special to get the option to paste as HTML or as text.
Firefox browser tends to keep the columns and layout together better than IE.

Great info shoto!

You can of course save the webpage to desktop, right-click and open with excel in XP.

[system]

programmer who is writing my system says html is no good was going to use risa form guides but costs a bit.and xcel doesnt seperate all info into seperate cells.well i havent been able to.i need starts wins placings p/money etc to be in seperate cells.

[lomaca]

programmer who is writing my system says html is no good was going to use risa form guides but costs a bit.and xcel doesnt seperate all info into seperate cells.well i havent been able to.i need starts wins placings p/money etc to be in seperate cells.

Programmer doesn't know what he is talking about.
Give me a shout if you like.
Most of us use Cyberhorse Zip files and it is not at all hard to parse it into a file suitable for importing into a database.
Cheers!

[system]

thanks mate will pass it on to him if he no good i,ll give ya yell.thanks to all who posted

[Shaun]

I copy and paste from 2 sites for my ratings and can get seperate information for what i need by using excel formulas the information i obtain is(Days since last start,beaten lengths last 3 runs,avearge prize money,win strike rate,track and distance percentages) it is not totaly automated and i can asses a race in about 5 minutes with good results....all for free....let me know if you are interested in shareing ideas.

Shaun

[system]

shaun sounds like you are using similar system to me,quite happy to share any info with you.just email at cb_fleming@hotmail.com

[Chuck]

Hey shaun can i please have a look at that spredsheet too? I don't want to sound like a follower but i have tried to create ratings using excel and it just hasn't worked - if not then can you tell me where you get your info?

Thanks in advance

Chuck

[Shaun]

What i can do is put together a small example sheet with the info and the code i use to extract what i need.....here is the site i used to get the code these guys are very good and helpfull if you explain what you need
http://www.mrexcel.com/board2/index.php

[Shaun]

I have put together a couple of sheets if you want to e-mail me

shaun2166@hotmail.com