Scraping webdata

[Cav]

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

thanks

[empty wallet]

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

[empty wallet]

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)

[Librettist]

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!

[johnt4124]

Edit > Paste Special >Text

[Gareth Flynn]

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

[Librettist]

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’

[Wallace]

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

[Librettist]

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!

[dave jay]

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.

[Author]

Posts