Is there a way to remove every character but numbers?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Is there a way to remove every character but numbers?
Date: 2012-02-05 13:47:41
Message-ID: 4F2E887D.3040108@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I need to clean up a text column so that it just contains numbers or the
"+" sign if it is the first character of the string.

Well, it is needed to normalise up a phone number column.
So it'd be great if the "+" could be transformed in "00" in the same step.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Viktor Bojović 2012-02-05 13:56:31 Re: Is there a way to remove every character but numbers?
Previous Message Dmitriy Igrishin 2012-02-03 20:21:49 Re: array dimensions, pg_catalog.pg_attribute and the \d command