Separate a URL from HTML

[Jeremye]

Hi,

I need help figuring out how to separate a url from html.

For example: <div class="ExternalClass0103788B7A354193AF0A6D766A486E97"><p><span style="font-size&#58;8.5pt;font-family&#58;arial, sans-serif;"><a href="https//THIS IS THE URL.com"><span style="color&#58;#097cbb...

I think I would need a Regex expression but I don't really understand the syntax to do it. Any help would be much appreciated! 

[FinnCharlton]

Hi @Jeremye , here is one way to do it with RegEx. In essence, you can copy and paste as much of the HTML around the URL as you want, and replace the URL with '(+?)'. This will search for this expression and return just the URL.

Hope this helps!

[FinnCharlton · Accepted solution]

Here's the syntax if you don't want the quote marks:

[Christina_H]

You can do this without RegEx too, in a couple of formulas.

Substring([Input],FindString([Input],'<a href="')+9)

Left([Output],FindString([Output],'">'))

[Jeremye]

Thank you!