Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Replace unwanted chars in data with a space?

Replace unwanted chars in data with a space?

From: Bob Maggio <rmaggio_at_courts.state.ny.usNOSPAM>
Date: Tue, 24 Jul 2001 18:17:24 GMT
Message-ID: <3B5DBC05.823F455B@courts.state.ny.usNOSPAM> 






Does anyone have a way of finding an unwanted char (say, a semi colon ;
)in a varchar2 data field and if it is found, removing it and replacing
it with a space? Preferabley, I would like to include a series of chars
to be seached for:


Something to take this:


Jordan; Rd.


and leave


Jordan Rd.


These are typos in conversion data that woun't pass our edits.  Thanks.
I've recieved much needed help from this group.
 Bob Maggio
Received on Tue Jul 24 2001 - 13:17:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US