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> 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)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
