If you were to pull out hyperlinks (or URLs) from a table, it would be fairly easy if it were in the beginning or end of the contents in a cell by using some combinations of the LEFT, MID, SEARCH or FIND functions. But if the URL in the text cells were all over the place and part of a paragraph in a cell, it might be more challenging or could involved using VBA. Common cases would be to pull out URLs with http, https or www and this video will show how to extract those type of URLs using Power Query.
Thursday, May 14, 2020
Extract Hyperlinks from Sentences in a Column
If you were to pull out hyperlinks (or URLs) from a table, it would be fairly easy if it were in the beginning or end of the contents in a cell by using some combinations of the LEFT, MID, SEARCH or FIND functions. But if the URL in the text cells were all over the place and part of a paragraph in a cell, it might be more challenging or could involved using VBA. Common cases would be to pull out URLs with http, https or www and this video will show how to extract those type of URLs using Power Query.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.