Thread: Re: [OT - sorta] How to extract a substring using Regex
> -----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.
-----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-----
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