Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Molnar
Subject Re: Regex help again (sorry, I am bad at these)
Date
Msg-id CACU0s5W4dOETAEiC=gapa0yVR9iadKWWHpLfThtwMboTaAhKTQ@mail.gmail.com
Whole thread Raw
In response to Re: Regex help again (sorry, I am bad at these)  (Félix GERZAGUET <felix.gerzaguet@gmail.com>)
List pgsql-general
Tree view
Thank you Felix that was exactly what I needed!

-Chris

On Mon, Dec 28, 2015 at 2:23 PM, Félix GERZAGUET <felix.gerzaguet@gmail.com> wrote:
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: Melvin Davidson
Date:
Subject: Re: Regex help again (sorry, I am bad at these)
Next
From: rob stone
Date:
Subject: Re: Options for complex materialized views sharing most of the same logic?