December 27th, 2006, 01:19 PM
|
|
Registered User
|
|
Join Date: Apr 2005
Posts: 22
Time spent in forums: 6 h 16 m 6 sec
Reputation Power: 0
|
|
Removing Illegal Characters???
Hello Hello all, its been sometime since I have been developing so I need some help from the men and women of Dev Shed. I am working with Oracle 10G, and have been working on setting up little pl/sql checks to make sure that the data that is imported is in the correct format.
The wall I have hit is removing illegal characters from the data I import. I have started to set something up where the string for a certain column must be be made of only there characters:
"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz-" (note that there is a - besides just letters) and I may want to add some other characters later. So basically the script will drop or replace any character not found in my definitions with "", thus removing the illegal character and joining the previous and next characters.
I thought for sure there would be a script posted somewhere online that did this but I can't find it and my syntax skills are lacking.
Thanks for the help!!!
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
