Friday, May 15, 2015

To remove control characters from strings

In case column has string data that is padded with junk characters that are not visible
You can use REGEXP_REPLACE to remove them.

SELECT length(REGEXP_REPLACE(column_name,'[[:cntrl:]]', '')), length(column_name),column_name from table_name;

No comments:

Post a Comment