So I guess regexp_replace can identify specialĬharacters, but I'm not sure my expression can However, I'm new to this construct, and I'm having doubts especially with the '|' and '^' operators in the expression.
Coda 2 replace special characters how to#
So I'm guessing here (a BIG guess) the opposite MIGHT work too.ĭo you think this statement will work? Since I don't know how to specify a range using chr() in regular expression, that's why I'm using posix. Select regexp_replace('This is a test $%&^*&*', '( | ] )', '$') from dual Īnd the whole string is turned into '$$$$$$$$. from dual) and using something like 'This is a test $%&^*&*' as input_string, and nothing is replaced. I've tried this in SQLPlus (using select. Processed_string := regexp_replace(input_string, '( | ^] )', '') (inside my function that takes an input string)
I've looked at the ASCII character map, and basically, for every varchar2 field, I'd like to keep characters inside the range from chr(32) to chr(126), and convert every other character in the string to '', which is nothing. I'm writing a function to remove special characters and non-printable characters that users have accidentally entered into CSV files. 1.7K Training / Learning / Certification.
0 kommentar(er)
