| From: | Vincas Dargis <vincas(dot)d(at)nensis(dot)lt> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: regexp_replace - replace non-numbers |
| Date: | 2008-10-28 15:02:33 |
| Message-ID: | 49072989.5030004@nensis.lt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Merlin Moncure wrote:
> On Tue, Oct 28, 2008 at 10:42 AM, Vincas Dargis <vincas(dot)d(at)nensis(dot)lt> wrote:
>
>> Hello everyone,
>>
>> I have problem with regexp_replace ( PostgreSQL 8.3.1). Please try this
>> crappy string replacement:
>>
>> select regexp_replace('abcd1235hgj!(at)#$^&^&*()[]-=', '[^0-9]*' ,'')
>>
>> ..and I get:
>> "1235hgj!(at)#$^&^&*()[]-="
>>
>>
>
> global flag:
> select regexp_replace('abcd1235hgj!(at)#$^&^&*()[]-=', '[^0-9]*' ,'', 'g');
>
> merlin
>
>
Thank you!
--
Geros dienos,
Vincas Dargis
Programuotojas
UAB "ProNENSIS"
Metalistų g. 10, Šiauliai, LT - 78136
Tel: +370 41 50 23 33
Faksas: +370 41 42 16 12
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2008-10-28 15:12:41 | Re: nearest neighbor search from xyz coordinates |
| Previous Message | Merlin Moncure | 2008-10-28 14:56:52 | Re: regexp_replace - replace non-numbers |