> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Josh Trutwin > Sent: Friday, August 24, 2007 7:58 AM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [OT - sorta] How to extract a substring using Regex > > On Fri, 24 Aug 2007 06:31:58 +0100 > Mark Cave-Ayland <mark.cave-ayland@xxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
