Detecting and Removing Special Characters

[djtom2000]

Hi,

I need to detect when a record is insert and updated in a character based field if the field has any special characters, particularly an apostrophe and remove them?

How would I do this?

e.g. Normal text "Tom's" Stripped out text "Toms"

Thanks

 

[Dagon]

select translate('Tom''s', 'a''', 'a') from dual

Gives:

Toms

 

[SantaMufasa]

Tom,

If you provide a comprehensive list of the special characters (or ASCII codes) that you want stripped, Dagon or I (or both) will be happy to provide code that does all the stripping you need.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]