Re: Removing tabs in strings with PL/SQL
Date: Mon, 29 Jan 2001 22:42:09 GMT
Message-ID: <954rju$lmb$1_at_nnrp1.deja.com>
Replace (string, chr(9),' ') will do the trick.
Perry
In article <954lqi$dh9$1_at_brokaw.wa.com>,
Patrick Ryan <pat_at_halcyon.com> wrote:
> 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/
>
Sent via Deja.com
http://www.deja.com/
Received on Mon Jan 29 2001 - 23:42:09 CET