Funtion to clean up strings?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Funtion to clean up strings?
Date: 2009-02-12 23:20:54
Message-ID: 4994AED6.5070306@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I need a function that removes characters in strings that aren't in a
given set of chars.
e.g
Input: 12-34/ 56(8)
I want just numbers so Output should in this case be: 1234568

Is there a solution?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dickson S. Guedes 2009-02-13 00:00:46 Re: Funtion to clean up strings?
Previous Message Frank Jördens 2009-02-11 03:55:26 Partitoning not working with RETURNING and INSERT/UPDATE