Hello Chris,
On Mon, Dec 28, 2015 at 8:10 PM, Christopher Molnar <cmolnar@xxxxxxxxxxxxxxxxxxxx> wrote:
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">https://owncloud.porterchester.edu/HVACR/PCI_GasHeat/GasElectrical/HVACR1114_LAB_13A.pdf" title="Lab 13A">Lab 13A<\a>', '/([^/]*)\" title=', '/&file=\1" title=')
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">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
