1. Forum
  2. Usenet
  3. UK.COMP.SYS.MAC

  • Re: How to extract a column of numbers from a website?

    From Ian McCall@21:1/5 to Commander Kinsey on Wed Nov 9 07:56:17 2022
    On 8 Nov 2022, Commander Kinsey wrote
    (in article <[email protected]>):

    https://www.boincstats.com/stats/-1/user/detail/6470/projectList

    I want the column of numbers under "world position" pasted into a spreadsheet. And I do it regularly, so I'm looking for an automated way. At the moment I have to type in every single number.

    I just selected the table, opened Numbers and pasted. Worked perfectly for
    the entire table, can pick up individual columns after.

    Cheers,
    Ian

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Alan B@21:1/5 to Ian McCall on Wed Nov 9 09:49:24 2022
    On 2022-11-09, Ian McCall <[email protected]> wrote:

    I just selected the table, opened Numbers and pasted. Worked perfectly for the entire table, can pick up individual columns after.

    Works with Excel too.

    --
    Cheers, Alan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Graeme Wall@21:1/5 to whisky-dave on Wed Nov 9 10:41:10 2022
    On 09/11/2022 10:18, whisky-dave wrote:
    On Wednesday, 9 November 2022 at 07:56:20 UTC, Ian McCall wrote:
    On 8 Nov 2022, Commander Kinsey wrote
    (in article <[email protected]>):
    https://www.boincstats.com/stats/-1/user/detail/6470/projectList

    I want the column of numbers under "world position" pasted into a
    spreadsheet. And I do it regularly, so I'm looking for an automated way. At >>> the moment I have to type in every single number.
    I just selected the table, opened Numbers and pasted. Worked perfectly for >> the entire table, can pick up individual columns after.

    Cheers,
    Ian

    Using a Mac in firefox you can hold down the cmd key to select text in a column, but this doesn't seem to work in safari
    Well not in catalina anyway.

    Or Ventura.

    --
    Graeme Wall
    This account not read.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From whisky-dave@21:1/5 to Ian McCall on Wed Nov 9 02:18:49 2022
    On Wednesday, 9 November 2022 at 07:56:20 UTC, Ian McCall wrote:
    On 8 Nov 2022, Commander Kinsey wrote
    (in article <[email protected]>):
    https://www.boincstats.com/stats/-1/user/detail/6470/projectList

    I want the column of numbers under "world position" pasted into a spreadsheet. And I do it regularly, so I'm looking for an automated way. At the moment I have to type in every single number.
    I just selected the table, opened Numbers and pasted. Worked perfectly for the entire table, can pick up individual columns after.

    Cheers,
    Ian

    Using a Mac in firefox you can hold down the cmd key to select text in a column, but this doesn't seem to work in safari
    Well not in catalina anyway.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Alan B@21:1/5 to Graeme Wall on Wed Nov 9 12:14:51 2022
    On Wed, 9 Nov 2022 10:41:10 +0000, Graeme Wall wrote:

    On 09/11/2022 10:18, whisky-dave wrote:
    On Wednesday, 9 November 2022 at 07:56:20 UTC, Ian McCall wrote:
    On 8 Nov 2022, Commander Kinsey wrote (in article
    <[email protected]>):
    https://www.boincstats.com/stats/-1/user/detail/6470/projectList

    I want the column of numbers under "world position" pasted into a
    spreadsheet. And I do it regularly, so I'm looking for an automated
    way. At the moment I have to type in every single number.
    I just selected the table, opened Numbers and pasted. Worked perfectly
    for the entire table, can pick up individual columns after.

    Cheers,
    Ian

    Using a Mac in firefox you can hold down the cmd key to select text in
    a column, but this doesn't seem to work in safari Well not in catalina
    anyway.

    Or Ventura.

    That's odd. In Safari on my Ventura system, I right clicked on the
    displayed left most column header (Project Name) and then did a Save Page
    as Page Source which created an html file on my hard drive. I opened this
    file in Safari and was able to select and copy the spreadsheet data which
    I then pasted into an empty Excel worksheet.

    --
    Cheers, Alan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Graeme Wall@21:1/5 to Alan B on Wed Nov 9 14:24:41 2022
    On 09/11/2022 12:14, Alan B wrote:
    On Wed, 9 Nov 2022 10:41:10 +0000, Graeme Wall wrote:

    On 09/11/2022 10:18, whisky-dave wrote:
    On Wednesday, 9 November 2022 at 07:56:20 UTC, Ian McCall wrote:
    On 8 Nov 2022, Commander Kinsey wrote (in article
    <[email protected]>):
    https://www.boincstats.com/stats/-1/user/detail/6470/projectList

    I want the column of numbers under "world position" pasted into a
    spreadsheet. And I do it regularly, so I'm looking for an automated
    way. At the moment I have to type in every single number.
    I just selected the table, opened Numbers and pasted. Worked perfectly >>>> for the entire table, can pick up individual columns after.

    Cheers,
    Ian

    Using a Mac in firefox you can hold down the cmd key to select text in
    a column, but this doesn't seem to work in safari Well not in catalina
    anyway.

    Or Ventura.

    That's odd. In Safari on my Ventura system, I right clicked on the
    displayed left most column header (Project Name) and then did a Save Page
    as Page Source which created an html file on my hard drive. I opened this file in Safari and was able to select and copy the spreadsheet data which
    I then pasted into an empty Excel worksheet.


    Ah, I was trying to extract a single column of data, as whisky-dave says
    you can do it in Firefox but not Safari. Grabbing the whole table is easy.

    --
    Graeme Wall
    This account not read.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Alan B@21:1/5 to Graeme Wall on Wed Nov 9 14:50:32 2022
    On Wed, 9 Nov 2022 14:24:41 +0000, Graeme Wall wrote:

    On 09/11/2022 12:14, Alan B wrote:
    On Wed, 9 Nov 2022 10:41:10 +0000, Graeme Wall wrote:

    On 09/11/2022 10:18, whisky-dave wrote:
    On Wednesday, 9 November 2022 at 07:56:20 UTC, Ian McCall wrote:
    On 8 Nov 2022, Commander Kinsey wrote (in article
    <[email protected]>):
    https://www.boincstats.com/stats/-1/user/detail/6470/projectList

    I want the column of numbers under "world position" pasted into a
    spreadsheet. And I do it regularly, so I'm looking for an automated >>>>>> way. At the moment I have to type in every single number.
    I just selected the table, opened Numbers and pasted. Worked
    perfectly for the entire table, can pick up individual columns
    after.

    Cheers,
    Ian

    Using a Mac in firefox you can hold down the cmd key to select text
    in a column, but this doesn't seem to work in safari Well not in
    catalina anyway.

    Or Ventura.

    That's odd. In Safari on my Ventura system, I right clicked on the
    displayed left most column header (Project Name) and then did a Save
    Page as Page Source which created an html file on my hard drive. I
    opened this file in Safari and was able to select and copy the
    spreadsheet data which I then pasted into an empty Excel worksheet.


    Ah, I was trying to extract a single column of data, as whisky-dave says
    you can do it in Firefox but not Safari. Grabbing the whole table is
    easy.

    Yes I was getting the whole set of columns via Safari and deleting the
    unwanted ones in a spreadsheet. Just tried Firefox and you're absolutely correct!!!

    --
    Cheers, Alan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)