Thank you Felix that was exactly what I needed!
-Chris
On Mon, Dec 28, 2015 at 2:23 PM, Félix GERZAGUET <felix.gerzaguet@xxxxxxxxx> wrote:
Hello Chris,
On Mon, Dec 28, 2015 at 8:10 PM, Christopher Molnar <cmolnar@xxxxxxxxxxxxxxxxxxxx> wrote:Any suggestions?
This seems to works:
select regexp_replace('<p>Complete the attached lab and submit via dropbox</p>\r<p><a href="" href="https://owncloud.porterchester.edu/HVACR/PCI_GasHeat/GasElectrical/HVACR1114_LAB_13A.pdf" target="_blank">https://owncloud.porterchester.edu/HVACR/PCI_GasHeat/GasElectrical/HVACR1114_LAB_13A.pdf" title="Lab 13A">Lab 13A<\a>', '/([^/]*)\" title=', '/&file=\1" title=')Regards,Félix
