Extract links by href from text file

[YasserKhalil]

Hello everyone
I have a text file which has html source for a web page and I need to extract the links according to specific pattern using regex
The pattern would be at the start point

Please Login or Register  to view this content.

and would be at the end point like that

Please Login or Register  to view this content.

So I need to extract the link from the start point in https and ends with ?dl=0
Example of valid link from the text file

Please Login or Register  to view this content.

Thanks advanced for help

[zbor]

Here:

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot for your solution
I need to extract all the links not only one. How can I achieve that?

Please Login or Register  to view this content.

[MarvinP]

Here is a UDF that will do that work.

Please Login or Register  to view this content.

Extract4Yasser VBA UDF.xlsm

[YasserKhalil]

Thank you very much Mr. Marvin
It works great. Now how can I extract all the instances not just the first instance?

[YasserKhalil]

Any help in this topic please?
How can I extract all the links in the text file

[YasserKhalil]

Can it be done using regular expressions?

[YasserKhalil]

I expected that this issue can be solved using regular expressions !!
It seems that I have to re-think of another workaround

[xlnitwit]

Perhaps this

Please Login or Register  to view this content.

[bakerman2]

I'd use this to keep it a bit cleaner to read.

Please Login or Register  to view this content.

[YasserKhalil]

That's awesome
Now this UDF grabs all links
I need only the links that starts with ("href": "https) and ends with (?dl=0", "file_id")

[xlnitwit]

My guess would be that the final output will not be a message box as I can't see the use, so I wasn't overly concerned about the formatting!

[YasserKhalil]

I would like the output to put each link in separate cell in column B

[xlnitwit]

Try changing the pattern like this

Please Login or Register  to view this content.

[xlnitwit]

Revision to output to column B

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very very much xlnitwit for this awesome and brilliant solution. That's exactly what I was searching for
Best and kind regards

[xlnitwit]

You're welcome. Thank you, and bakerman, for the rep!

[YasserKhalil]

How to change the pattern to include this part too in the links

Please Login or Register  to view this content.

[YasserKhalil]

I changed that line

Please Login or Register  to view this content.

But I need to know how to change the pattern itself

[xlnitwit]

Just move the bracket to include it

Please Login or Register  to view this content.

[YasserKhalil]

You are awesome. Thanks a lot for great help