Postgres Pro
Downloads
Home   >   mailing lists

Is there a way to remove every character but numbers? - Mailing list pgsql-sql

From Andreas
Subject Is there a way to remove every character but numbers?
Date
Msg-id 4F2E887D.3040108@gmx.net
Whole thread Raw
Responses Re: Is there a way to remove every character but numbers?  (Viktor Bojović <viktor.bojovic@gmail.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: array dimensions, pg_catalog.pg_attribute and the \d command
Next
From: Viktor Bojović
Date:
Subject: Re: Is there a way to remove every character but numbers?