I am attempting to extract a URL value from a string of Text, but cannot seem to get the entire URL
This is a sample of the text content:
Watch Now: https://tdh.streamingvideo.tn.gov/Mediasite/Play/abf43eb2772246e4bceba593ee85a4381d
July 16 2024 Tennessee Board of Dentistry Microsoft Teams meeting 11 am
Recorded: 7/16/2024 11:00:00 AM
Duration: 00:00:00
Test
The following expression should find the the substring pos of 'https' and the end should be the first space after that.
substring( variables('BoardMtgTxt'), lastIndexOf( variables('BoardMtgTxt'),'https'), indexOf(variables('BoardMtgTxt'), ' '))
From this, it's only giving me "https".
I've even tried using HTML_to_text and then performing the following:
substring( outputs('Html_to_text')?['body'], lastIndexOf( outputs('Html_to_text')?['body'],'https'), indexOf(outputs('Html_to_text')?['body'], ' '))
Either way, the result is the same:
Any assistance with extracting the full URL is deeply appreciated.
