Re: Remove whitespaces in varchar2

From: Lucyna Witkowska <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Fri, 1 Aug 2003 08:19:39 +0000 (UTC)
Message-ID: <bgd7qr$qd5$1@srv.cyf-kr.edu.pl>

Marc Eggenberger <marc.eggenberger_at_itc.alstom.com> wrote:

> I have several varchar2 columns which are updated from userinput in
> another db system. The user tend to enter the input in various ways.
> Some with spaces, some without, some with tabs etc etc ....

> I want to remove them before updating my main table with the data. When
> I do a replace(string1 IN VARCHAR2, pattern IN VARCHAR2) how can I
> specify whitespaces? Is there a special character as a replacement for
> Whitespaces like for example \w or similar or do I have to replace
> space, tab etc one by one?

> System is 8.1.7.0.0 on Windows.

TAB = chr(9), so:

translate(string1,'a '||chr(9),'a')

Regards,
LW Received on Fri Aug 01 2003 - 03:19:39 CDT