From: Michael Fuhr <mike@fuhr.org>
To: gurkan@resolution.com
Cc: pgsql-sql@postgresql.org
Subject: Re: regular expression
Date: Wed, 12 Oct 2005 15:03:37 -0600
Message-ID: <20051012210337.GA50999@winnie.fuhr.org> (raw)
In-Reply-To: <1129148927.434d71ffc0e13@www.resolution.com>
References: <1129148927.434d71ffc0e13@www.resolution.com>
[Please copy the mailing list on replies.]
On Wed, Oct 12, 2005 at 04:28:47PM -0400, gurkan@resolution.com wrote:
> Thanks for the reply. It helped a lot. I was goint to ask similar question
> regarding regular expression, but this time I need not the numeric part. What I
> mean is;
> say that this may be in these format
> "TSWUU" ---need--- "TSWUU"
> "4 - DSC" ---need--- "DSC"
> "6768 - THY" ---need--- "THY"
> basically string may or may not start with number,
> I need substring of character if it starts with number discard it
This isn't a PostgreSQL issue, but rather one of understanding how
regular expressions work in general. See the previously mentioned
"Pattern Matching" section of the PostgreSQL documentation for the
PostgreSQL-specific details, and use a search engine to find a
regular expression tutorial; they're frequently used in Perl and
other languages so a lot of learning material exists. If you can
find a copy in a library or bookstore, the book _Mastering Regular
Expressions_ by Jeffrey E. F. Friedl, published by O'Reilly, is a
good resource.
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, gurkan@resolution.com
Subject: Re: regular expression
In-Reply-To: <20051012210337.GA50999@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox