Postgres Pro
Downloads
Home   >   mailing lists

Re: Regex help again (sorry, I am bad at these) - Mailing list pgsql-general

From Félix GERZAGUET
Subject Re: Regex help again (sorry, I am bad at these)
Date
Msg-id CANVwZtvVWt95hc0On+KbtqEbYrw04Au5qSkKvtod5+6zBCW9sw@mail.gmail.com
Whole thread Raw
In response to Regex help again (sorry, I am bad at these)  (Christopher Molnar <cmolnar@ourworldservices.com>)
Responses Re: Regex help again (sorry, I am bad at these)  (Christopher Molnar <cmolnar@ourworldservices.com>)
List pgsql-general
Tree view
Hello Chris,

On Mon, Dec 28, 2015 at 8:10 PM, Christopher Molnar <cmolnar@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
 

pgsql-general by date:

Previous
From: Christopher Molnar
Date:
Subject: Regex help again (sorry, I am bad at these)
Next
From: Melvin Davidson
Date:
Subject: Re: Regex help again (sorry, I am bad at these)