Re: Removing tabs in strings with PL/SQL

From: Patrick Ryan <pat_at_halcyon.com>
Date: 29 Jan 2001 21:03:14 GMT
Message-ID: <954lqi$dh9$1_at_brokaw.wa.com>


[Quoted] A better method is to use the REPLACE function

REPLACE (string, chr(20), ' ')

(I think tab is chr(20), you'll wanna check)

Happy coding!

gregteets_at_my-deja.com wrote:
> I have a column of text. Some of the strings in
> the table have tabs in them. I have been working
> with LTRIM in PL/SQL to remove the tabs but cannot get it
> to work.
 

> I assume I would set the second parameter to a
> tab, presumably using the ASCII code for tab.
 

> If someone has done this, please let me know how
> to do it.
 

> Thank you.
 

> Greg Teets
> Cincinnati, OH

> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 29 2001 - 22:03:14 CET

Original text of this message