The home of intelligent horse racing discussion
The home of intelligent horse racing discussion

Scraping webdata

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #1308
    CavCav
    Participant
    • Total Posts 4809

    Is there any suitable software for extracting cards data from the RP website into an excel spreadsheet?

    thanks

    #50632
    empty walletempty wallet
    Member
    • Total Posts 1631

    Copy, select cell, click paste special, click unicode text – job done

    #50633
    empty walletempty wallet
    Member
    • Total Posts 1631

    Or

    Copy and paste into sheet,( it’ll be in HTML format), copy and paste that onto a new sheet, Paste Special pop up appears, select "values"

    job done

    (Edited by empty wallet at 5:30 pm on April 5, 2007)

    #50634
    Librettist
    Member
    • Total Posts 559

    on a related problem, does anyone know how to copy a sentence which has a comma in it and paste it into a single cell (on excel), without all the words after the comma being automatically pasted in the next cell along?

    Sorry if that dosen’t make sense!

    #50635
    johnt4124
    Member
    • Total Posts 36

    Edit > Paste Special >Text

    #50636
    Gareth Flynn
    Participant
    • Total Posts 583

    Double click on the cell so you’re ‘inside’ it when you do the paste.

    #50637
    Librettist
    Member
    • Total Posts 559

    It still won’t allow me to paste anything with a comma in it without it automatically shifting all text after the comma to the next cell.

    Also, the ‘paste special’ option is not highlighted to use, just ‘paste’

    #50638
    Wallace
    Participant
    • Total Posts 862

    Don’t use a right click but select Paste special from the Edit menu and you will be offered an option to select text.

    #50639
    Librettist
    Member
    • Total Posts 559

    thanks for your help but it still won’t let me ‘paste special’. Everything else is highlighted on the drop down menu except that, even after i’ve copied some text to the clipboard. I hate computers!

    #50640
    dave jay
    Member
    • Total Posts 3386

    This is something to do with your default settings on your ‘import data’ function. If you go to tools .. options (in excel) and then look through that, there should be something in there. Failing that go to on-line help.

    Excel is reading comma as a break point by default. I had the same problem with weight being imported as a date.

Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.