Hi Guys,

I want to extract all the URLs from this sitemap: http://tinyurl.com/zhhd2vj

The URLs are between a lot of different text which makes it tricky.

The URLs start with https:// and then end with /

Example:

screenshot.2051.jpg

I have tried using text to columns with excel but have had no luck.

Any ideas on other ways to do this?

I have uploaded the sitemap in notepad format at this link if it helps: http://www.filedropper.com/sitemapdata

Thanks,
Chris