You're not really clear what you are looking to filter out. (Or maybe I'm not reading it correctly.)
Are you trying to make the whole field value null? Or are you just trying to yank out specific characters?
On one level, look at the REPLACE function if you know specifically what you want to take out.
But if you want to take out any of a whole bunch of characters and strings, you want to look at the REGEXP_REPLACE() function.
I have only used it lightly. There is a whole world of REGEXP stuff out there available to you.
I have attached an old REGEXP example I picked up a long time ago. It's yanking a bunch of stuff from a string, leaving the result as 1234567.
regexp.twbx 2.3 MB
Sorry for the Confusion on this. Trying to make the whole field Null if there in a [a-z] in the value.
1 of 1 people found this helpful
You probably want to look at REGEXP_MATCH(). It will tell you if the string contains any of the target characters, and return TRUE if so.
Check out using REGEX here:
Yep, I checked that from the first one. My problem was that I was not using an Extract after converting to a extract I was able to use the REGEX_MATCH with no problems at all. Appreciate the help