Regular Expression in Teradata

Database

Regular Expression in Teradata

Hi All,

I have a requirement to find the control characters in a column's data and it should be replaced by a Character/Symbol using Regular Expression in Teradata..How to find control characters in the sample data below

Logic:- regexp_replace('Vjhbw Tsj 884 IV MY 377t','[[:cntrl:]]','|')

Sample Data:-Vjhbw Tsj 884 IV MY 377t

What will be output after Reg Expression...

Thanks & Regards,

Venkatesh Kumar Saluvathi

Tags (1)