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

From: Lee Keel <lee(dot)keel(at)uai(dot)com>
To: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: [OT - sorta] How to extract a substring using Regex
Date: 2007-08-24 14:41:15
Message-ID: 76758090F8686C47A44B6FF52514A1D308C9CA98@hermes.uai.int
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Josh Trutwin
> Sent: Friday, August 24, 2007 7:58 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] [OT - sorta] How to extract a substring using Regex
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/

As long as we are talking about regex tools... I found this tool a while
back and today I don't know how I ever figured out regular expressions
without it. (http://www.regexbuddy.com/) Unfortunately it is not free, but
for the time that it saves, it is WELL worth $40 a copy. In fact, I
personally bought it and was going to charge back to my company, but decided
I would keep the licenses myself.
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Trutwin 2007-08-24 14:43:59 ERD of information_schema / system catalog?
Previous Message roy simkes 2007-08-24 14:18:27 tsearch query question