Problems cut and pasting stats/table from NFL.com in Safari

Discussion in 'Mac Apps and Mac App Store' started by avincent52, Jan 14, 2008.

Most Liked Posts
  1. avincent52, Jan 14, 2008

    avincent52 macrumors regular

    Joined:
    Nov 6, 2007
    #1
    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
     
    share
    + Quote Reply
  2. bastett, Mar 23, 2008

    bastett macrumors newbie

    Joined:
    Mar 23, 2008
    #2
    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.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page