Thank you Felix that was exactly what I needed! -Chris
On Mon, Dec 28, 2015 at 2:23 PM, Félix GERZAGUET <felix.gerzag...@gmail.com> wrote: > Hello Chris, > > On Mon, Dec 28, 2015 at 8:10 PM, Christopher Molnar < > cmol...@ourworldservices.com> wrote: > >> Any suggestions? >> > This seems to works: > > select regexp_replace('<p>Complete the attached lab and submit via > dropbox</p>\r<p><a href=" > 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 > >