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

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

From
Lee Keel
Date:
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Josh Trutwin
> Sent: Friday, August 24, 2007 7:58 AM
> To: pgsql-general@postgresql.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.cave-ayland@ilande.co.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
entityto whom they are addressed. If you have received this email in error please notify the sender. This message
containsconfidential information and is intended only for the individual named. If you are not the named addressee you
shouldnot disseminate, distribute or copy this e-mail. 

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

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Lee Keel wrote:
>> -----Original Message-----

>>
>> ---------------------------(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
entityto whom they are addressed. If you have received this email in error please notify the sender. This message
containsconfidential information and is intended only for the individual named. If you are not the named addressee you
shouldnot disseminate, distribute or copy this e-mail. 

Woah! That is great. Now to find a linux version.

Joshua D. Drake

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGzvScATb/zqfZUUQRAnBRAKCcMesTYri0caOiNzShMwTXXw137ACfcLxu
3Egy0J00iFIaFFfl9KiOlc0=
=rlVZ
-----END PGP SIGNATURE-----

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

From
Dimitri Fontaine
Date:
Le Friday 24 August 2007 17:09:16 Joshua D. Drake, vous avez écrit :
> > 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/)
>
> Woah! That is great. Now to find a linux version.

Does this tool looks like the one you'd wanna find?
  http://www.blackie.dk/KDE/KRegExpEditor/
  http://docs.kde.org/stable/en/kdeutils/KRegExpEditor/

Regards,
--
dim