RE: PL/SQL : how to drop all the white characters from a string

THANX a lot to all who replied !!! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 05, 2001 7:32 PM To: Multiple recipients of list ORACLE-L You guys are all doing this the hard way! Regular expressions to the rescue!

PL/SQL : how to drop all the white characters from a string

Dear all ! I need a PL/SQL proc that will drop all the white characters (spaces , tabs , enters etc.. ) from a string stored in a VARCHAR column I'm not trying to load my work to others , but ... if U have such a proc ready , would U please share . Thanks a lot in advance. DBAndrey *

RE: PL/SQL : how to drop all the white characters from a string

Andrey, how about the function below. you can change the SUBSTR commands below to tailor to your use. To use the function, you can : update {table} set column_name = wtw_name_fix(column_name); hope this helps. CREATE OR REPLACE FUNCTION WTWDBA.Wtw_Name_Fix(in_string IN VARCHAR2)

RE: PL/SQL : how to drop all the white characters from a string

Many thanks to all who replied !!! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 05, 2001 3:20 PM To: [EMAIL PROTECTED] Hi, An example to remove the spaces using the translate function is as follows. create table test

RE: PL/SQL : how to drop all the white characters from a string

Now HERE is something to research.. thanks Jared! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 05, 2001 1:32 PM To: Multiple recipients of list ORACLE-L You guys are all doing this the hard way! Regular expressions to the rescue!

Re: PL/SQL : how to drop all the white characters from a string

You guys are all doing this the hard way! Regular expressions to the rescue! Here's a complete test: declare tstr varchar2(100) := 'this contains tabsmultiple spaces and single spaces'; begin dbms_output.put_line( tstr); owa_pattern.change( tstr, '\s', '', 'g');