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 <robjsarg...@gmail.com
<mailto:robjsarg...@gmail.com>> 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@postgresql.org
<mailto:pgsql-general@postgresql.org>)
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
