Re: [OT - sorta] How to extract a substring using Regex

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [OT - sorta] How to extract a substring using Regex
Date: 2007-08-24 12:58:01
Message-ID: 20070824075801.00861a70@sinkhole.intrcomm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 24 Aug 2007 06:31:58 +0100
Mark Cave-Ayland <mark(dot)cave-ayland(at)ilande(dot)co(dot)uk> wrote:

> > substring(data_field from '<name>(.+)<\/name>')
>
> FWIW, I find the following site extremely useful when trying to
> create moderately complex regular expressions: http://www.rexv.org.

Nice site - here's another good one for an installed app that is
excellent for even advanced regexp's:

http://weitz.de/regex-coach/

It used to be cross-platform but now he only develops a Windows
version.

Thanks,

Josh

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Markus Schiltknecht 2007-08-24 13:21:10 Re: Geographic High-Availability/Replication
Previous Message Andrus 2007-08-24 12:56:12 Re: reporting tools