Enfocus Community

I have found the following Regular Expression very useful to look for a URL in a long text string:

(ftp:\/\/|www\.|https?:\/\/){1}[a-zA-Z0-9u00a1-\uffff0-]{2,}\.[a-zA-Z0-9u00a1-\uffff0-]{2,}(\S*)

Used on the following text string:

<td bgcolor="white" style="padding:5px !important;” class=“”><a href="https://www.jotformeu.com/uploads/Terke ... /DEMO.xlsx" class="">DEMO.xlsx</a></td>

... it will return this:

https://www.jotformeu.com/uploads/Terke ... /DEMO.xlsx"

It works very well with variables in Switch. The only problem is the dobbelt quote at the end of the string, so I changed the RegEx to this:

(ftp:\/\/|www\.|https?:\/\/){1}[a-zA-Z0-9u00a1-\uffff0-]{2,}\.[a-zA-Z0-9u00a1-\uffff0-]{2,}(\S[^"]*)

... adding [^"] to Group 2

Checking this in different online RegEx evaluators, it works fine, but if I use it in Switch, it breaks everything and only returns this: *)"].

Could anybody tell me how to change the RegEx to exclude the dobbelt quote at the end of the URL, AND have it work in Switch?

I've found Switch likes having this expression fully quantified i.e ... and often works best without the comma if that's possible.

Also, where I've had a longer expression, sometimes enclosing the entire thing once more in '(' and ')' can help.

from to this sort of thing.

Excuse my ignorance, but I don't think I understand how this could solve the problem?

I need a way to exclude the double quote (") from the result that is returned. In a javascript RegEx this would work but it can't be used inside Switch

Hi Terkelsen

This regexp seems to do it:

(http|ftp|https)://([\w_-]+(?:(?:\.[\w_-]+)+))([\w.,@?^=%&:/~+#-]*[\w@?^=%&/~+#-])?

HTH

Loic
www.ozalto.com

Hi Loic,

That was a different approach but it solves the problem

Thanks a lot.

You're welcome !