Thread: strip a character from text

strip a character from text

From
nngodinh@tiscali.it
Date:
Greetings,

Does anyone know a function that strips ANY occurence of a given character
from a TEXT?

Thx.

Nhan NGO DINH


__________________________________________________________________
Tiscali Ricaricasa
la prima prepagata per navigare in Internet a meno di un'urbana e
risparmiare su tutte le tue telefonate. Acquistala on line e non avrai
nessun costo di attivazione né di ricarica!
http://ricaricasaonline.tiscali.it/





Re: strip a character from text

From
Oliver Elphick
Date:
On Wed, 2002-09-18 at 11:18, nngodinh@tiscali.it wrote:
> Greetings,
> 
> Does anyone know a function that strips ANY occurence of a given character
> from a TEXT?

It sounds like a job for a PL/Perl function.

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                            
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "Give, and it shall be given unto you; good measure,      pressed down, and
shakentogether, and running over,      shall men pour into your lap. For by your standard of      measure it will be
measuredto in return."                                          Luke 6:38 
 



Re: strip a character from text

From
nngodinh@tiscali.it
Date:
I'm about to write a C function... If I can't found alternatives.

>-- Messaggio Originale --
>Subject: Re: [HACKERS] strip a character from text
>From: Oliver Elphick <olly@lfix.co.uk>
>To: nngodinh@tiscali.it
>Cc: pgsql-hackers@postgresql.org
>Date: 18 Sep 2002 13:30:49 +0100
>
>
>On Wed, 2002-09-18 at 11:18, nngodinh@tiscali.it wrote:
>> Greetings,
>>
>> Does anyone know a function that strips ANY occurence of a given character
>> from a TEXT?
>
>It sounds like a job for a PL/Perl function.
>
>--
>Oliver Elphick                                Oliver.Elphick@lfix.co.uk
>Isle of Wight, UK
>http://www.lfix.co.uk/oliver
>GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                 ========================================
>     "Give, and it shall be given unto you; good measure,
>      pressed down, and shaken together, and running over,
>      shall men pour into your lap. For by your standard of
>      measure it will be measured to in return."
>                                           Luke 6:38
>


__________________________________________________________________
Tiscali Ricaricasa
la prima prepagata per navigare in Internet a meno di un'urbana e
risparmiare su tutte le tue telefonate. Acquistala on line e non avrai
nessun costo di attivazione né di ricarica!
http://ricaricasaonline.tiscali.it/





Re: strip a character from text

From
Joe Conway
Date:
nngodinh@tiscali.it wrote:
> I'm about to write a C function... If I can't found alternatives.
> 
> 

Note that in 7.3 (in beta now) there is a new replace() function which will do 
this:

regression=# select replace('abcdefghabcdef','c','');   replace
-------------- abdefghabdef


Joe