Extract URL from string

[alexgoaga]

Hello, I have a question regarding the possibility of extracting the URL and display it (example msgbox, or debug.print) from different sets of strings

The easy cases ?
"Hey , enter here www.google.com" -> the site will be "www.google.com"
"Hey , enter here http://www.google.com" -> the site will be "http://www.google.com"

But the hard cases for example would be
1) Images
"Hey , check out this image https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png" and the link would be the entire image "https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png"

2) Direct Links
"hey enter here google.com" -> the site will be "google.com"

For the easy cases i would have an idea about to search for www. or http in string and search for the first empty space? i think...but for the hard cases?

Thank you

[WideBoyDixon]

You could try using regular expressions to extract the URL:

Please Login or Register  to view this content.

See attached.

WBD

[6StringJazzer]

Please be aware that looking for www is a red herring, as it is an arbitrary convention and not a standard. A URL for a web page doesn't have to start with www (ex: https://boards.straightdope.com/sdmb/index.php)

WBD, I get a #NAME error for this sample input:

My album is at http://www.seiglefamily.com/photos.php?dir=2018alaska&cols=1&cappos=right&ppp=10

but I haven't dissected your regexp yet to figure out why. (But the OP may not care about a case like this.)

[WideBoyDixon]

Please be aware that looking for www is a red herring, as it is an arbitrary convention and not a standard. A URL for a web page doesn't have to start with www (ex: https://boards.straightdope.com/sdmb/index.php)

WBD, I get a #NAME error for this sample input:

My album is at http://www.seiglefamily.com/photos.php?dir=2018alaska&cols=1&cappos=right&ppp=10

but I haven't dissected your regexp yet to figure out why. (But the OP may not care about a case like this.)

Yep. A solid regular expression would probably run into hundreds of characters. I was aiming at the provided examples only. Complex URLs with parameters won't work with the above.

WBD

[alexgoaga]

Hey Jeff,
After receiving the RegExp i've tested over ~30 cases that i would think that would break the normal flow of the code but didn't find anything that raised any concerns. Also i've tested again your code and worked perfectly on my side (see picture attached)

I know that searching for arbitrary convention is not a good manner but i didn't had any idea at the moment so i asked here

Thank you for your time explaining every detail. It has been noted down.



For further info:
I am using the latest update available for office 2016 x86 system on Windows 10 Pro x64.

Thank you for your time

[6StringJazzer]

That is interesting. Excel 2013 on Windows 10 Pro x64.
namerror.JPG

[alexgoaga]

That is interesting. Excel 2013 on Windows 10 Pro x64.
Attachment 590281

I'm back with another test, 6StringJazzer, tested on the latest Excel 2016 x64 on Windows 10 Pro x64. on a virtual machine, works like a glove.