On 1/14/2016 2:02 PM, John McKown wrote:
How about:select regexp_replace('71.09.6.01.3', '(\d)[.-]', '\1', 'g'); match is 1.3 and result is 13 ( 71096.013). If you don't want to eliminate the period or dash unless it is _between_ two digits, try: select regexp_replace('71.09.6.01.3', '(\d)[.-](?=\d)', '\1', 'g'); (?=\d) is a "look ahead") match which says that the period or dash must be followed by a digit, but the expression _does not_ "consume" the digit matched. Maranatha! <>< John McKown
Yes, excellent, both seem to work. I'll run a bunch of data through them both and see what happens.
Thanks much for the help! -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
