Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

avincent52

macrumors regular
Original poster
Nov 6, 2007
104
0
I'm generally happy with Safari 3 with one exception.
I use data from sites like the page below from NFL.com and try to copy and paste it into Excel.

http://www.nfl.com/stats/categorystats?tabSeq=0&statisticCategory=PASSING&conference=null&season=2007&seasonType=POST&d-447263-s=PASSING_YARDS&d-447263-o=2&d-447263-n=1

When I do, it doesn't look like a table, but a long string of data all in column A.

It's not garbled like this this when I open the page and copy and paste from Firefox.

Is there something obvious I'm doing/not doing that's causing this in Safari?
I'd like to stick to one browser if at all possible.

best
Allen
 
Odd cell delineation from an html table in Safari

Hi there,

I'm having a similar problem but with AFL (Aussie Rules).
After some investigation it seems to be the way mac (or safari) deals with copy and pasting a table from Safari. On windows (and linux) using firefox, I got a space followed by a tab between cells, but the mac seems to do something else.

When pasting (as you noted) into excel or word, each cell seems to terminate with a new line. When pasting into a web form, they seem to be delineated with spaces (which causes its own problems for parsing the text).

I'll keep looking into it.

Bastett

Edit: I've just solved it, for my problems at least, though it's not going to help you with excel I'm afraid.
After a little investigation, if you paste into TextEdit first, you'll get data with rows delineated by CRLF (carriage return, line feed) and cells separated by tabs. If you then copy it from TextEdit and paste into excel, that should work.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.