Re: regexp idea

From: AI Rumman <rummandba(at)gmail(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: regexp idea
Date: 2013-08-27 20:04:08
Message-ID: CAGoODpfMo6i0j6WGD-4ZhD1rHy7qD6oJbLUWVxJpUcDoOcV9cQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2013-08-27 20:07:18 Re: regexp idea
Previous Message Rob Sargent 2013-08-27 19:57:38 Re: regexp idea