Results 1 to 3 of 3

Thread: Return hyperlinks from web pages with Power Query?

  1. #1
    Acolyte Charley's Avatar
    Join Date
    Jul 2017
    Posts
    62
    Articles
    0
    Excel Version
    365

    Return hyperlinks from web pages with Power Query?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    If I use Power Query to return hyperlinked content from a web page, the content isn't hyperlinked when it's returned to Excel.

    Is there way to either add a column to the Table with the URLs of the hyperlinks in an adjacent column, or else return hyperlinked text?

    Thanks.

    Charley

  2. #2
    Conjurer Rudi's Avatar
    Join Date
    Jan 2014
    Location
    Cape Town, RSA
    Posts
    134
    Articles
    0
    Excel Version
    Excel 365 ProPlus
    Hi Charley,

    The gurus here might come up with a smarter or more convenient way to do this; but here is my 2 cents reply.
    NOTE: I have not had the time to test out the advice in the links below, but its worth a try to see if it provides you some solution.

    See the two replies from hobbitalex at the bottom of this page.
    It shows a way to extract the links with a binary import and then to merge it with the web page import to get the links.

    See this page which shows how to use a formula in PQ to convert web addresses into friendly named and clickable hyperlinks

    If necessary here is some additional info from Chris Webb to show how one can extract web addresses from text using Text.BetweenDelimiters()
    Regards,
    Rudi
    www.eileenslounge.com

  3. #3
    Acolyte Charley's Avatar
    Join Date
    Jul 2017
    Posts
    62
    Articles
    0
    Excel Version
    365
    Rudi,

    Thank you very much! Chris's article was exactly what I needed!

    Charley

Tags for this Thread

Posting Permissions

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