I need to extract the url inside the string

Question

I need to extract the url inside the string.

In my case html text is in the db and when i get that text and need to find all url in the text and insert in to another table, can u give me a way to find the url's in SQL or C#.

http://stackoverflow.com/questions/4750015/regular-expression-to-find-urls-within-a-string — Jakub Malec, Aug 23 '13 at 08:52

score 1 · Answer 1 · answered Aug 23 '13 at 08:52

This is reqular expression to find urls in text

Regex regx = new Regex("http://([\\w+?\\.\\w+])+([a-zA-Z0-9\\~\\!\\@\\#\\$\\%\\^\\&amp;\\*\\(\\)_\\-\\=\\+\\\\\\/\\?\\.\\:\\;\\'\\,]*)?", RegexOptions.IgnoreCase);

MatchCollection mactches = regx.Matches(txt);

score 0 · Answer 2 · edited May 23 '17 at 12:21

One of the possible ways to do it is by using Regular expressions. First option is to extract HTML from the DB, then use Regular Expression to find the links directly. The second option is to locate link tags first, then extract url from them (again by using Regular expressions).

Here you can find information about how to use Regular Expressions in C#: http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.regex.aspx

On the other hand, writing the correct Regular Expression may not be so easy (it depends on how complex the URL is), but you should take a look at this question: regular expression for url

Also, here you can find a lot of information about regular expressions in general (keep in mind that there are some applications like RegexBuddy, that can help you a lot when it comes to testing your regular expressions): http://www.regular-expressions.info/

I need to extract the url inside the string

2 Answers2