regexp_replace - Mailing list pgsql-general

From Andy Colson
Subject regexp_replace
Date
Msg-id 5697FA5F.2020703@squeakycode.net
Whole thread Raw
Responses Re: regexp_replace  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: regexp_replace  (John McKown <john.archie.mckown@gmail.com>)
Re: regexp_replace  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Hi all.

This is not doing as I'd expected:

select regexp_replace('71.09.6.01.3', '(\d)[.-](\d)', '\1\2', 'g');

  regexp_replace
----------------
  71096.013
(1 row)

It acts the same with dashes:
select regexp_replace('71-09-6-01-3', '(\d)[.-](\d)', '\1\2', 'g');

  regexp_replace
----------------
  71096-013
(1 row)

I cannot use translate because there is other text in the field.  I'm
trying to strip masking characters from a parcel number in a larger text
field (for example:  "the parcel 12-34-56 has caught on fire")

I seem to be missing something, any hints?

I'm on PG 9.3.9 on Slackware64.

Thanks for your time,

-Andy


pgsql-general by date:

Previous
From: Nikhil
Date:
Subject: Postgres BDR bdr_init_copy fails
Next
From: Tom Lane
Date:
Subject: Re: regexp_replace