read the url of a link within href

[Asisgar]

Hi,

I want to make an automation so that it reads me an email that has in its content the word "enlace" with a hyperlink so that it saves the link file. I have one that does it well when the url is written in the body of the message, but this one, where the url is only in code as a hyperlink of the word enlace, gives me the result that match is null

function main(workbook: ExcelScript.Workbook, inputHtml: string): string {
   // Regular expression to find a hyperlink where the word 'link' appears
   // This regex specifically looks for the structure observed in your HTML
   const regex = /<a\s+(?:[^>]*?\s+)?href="([^"]*)"[^>]*>(.*?)link(.*?)< \/a>/is;

   // Search the provided HTML
   const match = inputHtml.match(regex);

   // Check if a match was found
   if (match && match[1]) {
     // Return the URL found
     return match[1]; // match[1] contains the captured URL
   }



   // Return a message if no URL is found
   return "The match variable is " + match + "Not recognized as a link. The regex variable is: " + regex + "And inputHtml is: " + inputHtml.substring(0, 1000);

I try this regex:

  const regex = /<a\s+href="([^"]+)"[^>]*>\s*enlace\s*<\/a>/i;

  const regex = /<a[^>]*href="([^"]*)"[^>]*>(.*?)enlace(.*?)<\/a>/i;

  const regex = /enlace.*?href="([^"]*)"/i;

but it always returns null

[Chriddle]

https://regex101.com/

[AlexEncodian]

@Asisgar 

Try this Regex:

Utility - Extract URL's from Text

[Asisgar1]

Thank you!

Very interesting application, what language should I use for my case in Power Automate? because it gives me an error in all the regex, even the ones that work within power automate

[Asisgar1]

Thank you!
And if the url, as I have already mentioned is my case, is not in the text but in the html code?

[Asisgar]

It turns out that the problem is that it was an indirect link, I had to access the page with an http action twice and in between extract the url from the result of the first http