Hi,
By using regexp_like and regexp_replace, how to find non printable characters from a string.
See Also
SQL Statement to Remove Part of a String - GeeksforGeeksW3Schools.comOracle TRIM, LTRIM & RTRIM Function Guide, FAQ & ExamplesUse SUBSTR to Remove the Last Character from any String in Oracle SQLColumn1
000000000#
€˜0051400
would like to remove # and € and all special characters which are of €, which are not readable by the keyboard.
select * from table1 where REGEXP_LIKE(column1, '[^A-Z^a-z^0-9^[^.^{^}]' ,'x');
please advise.
Thanks
Aman
