Re: regexp idea

[Rob Sargent <robjsargent@xxxxxxxxx>]

On 08/27/2013 02:04 PM, AI Rumman wrote:

Thanks. That's awesome.

Do you have any good guide where I may get more knowledge on REGEXP?

On Tue, Aug 27, 2013 at 3:57 PM, Rob Sargent <robjsargent@xxxxxxxxx> wrote:

On 08/27/2013 12:44 PM, AI Rumman wrote:

Hi,

I have a string like:
Gloucester Catholic vs. St. Augustine baseball, South Jersey Non-Public A final, June 5, 2013

I need to extract date part from the string.

I used the follows:
regexp_matches(title,'[.* ]+\ (Jul|August|Sep)[, a-zA-Z0-9]+' )

But it gives me result August as it stops at "Augustine".

In my case, date can be in different formats, some record may use "," or some may not.

Any idea to achieve this?

Thanks.

select regexp_replace('Gloucester Catholic vs. St. Augustine baseball, South Jersey Non-Public A final, June 5, 2013', E'(^.*)(\\m(June|July|August|Sep))([, a-zA-Z0-9]+)', E'\\2 \\4' );
+----------------+
| regexp_replace |
+----------------+
| June  5, 2013  |
+----------------+
(1 row)

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

http://www.postgresql.org/docs/9.1/static/functions-matching.html is the best starting point