Results 1 to 6 of 6

Thread: help: beginner trying to download PQS log

  1. #1
    Join Date
    Apr 2012
    Posts
    8

    Default help: beginner trying to download PQS log

    Hi,

    On my iMac I click on "all" under National League on a PQS log page. I get a blue HQ webpage: "your file has been generated - to download it click here. I click and get another webpage full of the data, separated by commas and messy. Is there something I can do next to put this into Excel? I have tried various copy and paste things with only a messy paste in Excel that I cannot manipulate.

    The above happens consistently now. In one of my first efforts at this somehow I did get a download in my downloads folder. It was an html file and my efforts to get that into Excel likewise failed.

    Appreciate any guidance you can offer, thanks.

  2. #2
    Join Date
    May 2003
    Location
    Westwood, MA
    Posts
    46,509

    Default

    What browser are you using? Some of this stuff doesn't work as cleanly in Safari. Would suggest you download Firefox, that's our Mac-recommended browser.

  3. #3
    Join Date
    Feb 2012
    Location
    Old England
    Posts
    431

    Default

    If you copy the "comma'd website" date and "Paste Special" it into a cell of an Excel sheet (I usually use B2 in case I want to add anything above or to the left of it), you should get all the data in one cell.

    Then choose Data, Text To Columns, click on the Delimited option button, then the Next button, clear everything but check the Comma box, then click on Next button. Having done that I HOPE that all the data has slotted itself into tidy columns.

    Fingers crossed.

    PS - if the date spreads itself across a load of columns when you Paste Special it into Excel, then close Excel and open it again before re-trying.

    I also forgot to say that when you choose Edit and PasteSpecial, choose the Text option, not the HTML option...
    Last edited by Penfold; 04-23-2012 at 07:58 AM. Reason: PS added

  4. #4
    Join Date
    Apr 2012
    Posts
    8

    Default

    It is Safari, Ray, thanks. I'll try Firefox. Jim

  5. #5
    Join Date
    Apr 2012
    Posts
    8

    Default

    thanks Penfold - will give it a try

  6. #6
    Join Date
    Apr 2012
    Posts
    8

    Default

    thanks Penfold - that's working for me

Similar Threads

  1. stats for download
    By BERSMR in forum HQ Tech Support
    Replies: 1
    Last Post: 04-06-2007, 04:07 AM
  2. download key for rotolab
    By duncanI in forum HQ Tech Support
    Replies: 1
    Last Post: 08-11-2006, 05:16 PM

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •