Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Remove whitespaces in varchar2
Do You mean ' ' (one space) and ' ' (two spaces) and so forth ?
"Marc Eggenberger" <marc.eggenberger_at_itc.alstom.com> schrieb im Newsbeitrag
news:MPG.1992f0d5e63e7df89896bf_at_iww.cacti.ch.alstom.com...
> Hi there.
>
> 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.
>
> thanks for any hints.
>
> --
> mfg
> Marc Eggenberger
Received on Thu Jul 31 2003 - 03:28:47 CDT