Hello,
I have inherited an application from a previous employee and it is using an oracle view to present data to an external system. In this SQL view is a regular expression to remove some special characters (see below). I believe from reviewing the SQL that they are trying to remove tab and carriage return characters from a data field, however what we have noticed recently is that it also removes the lower case letter "t" at the beginning of line of text in the data field. This seems strange to me but I guess it is to do with the "(^\t)"
REGEXP_REPLACE (pr_addtl_data_439.s_value,'([[:cntrl:]])|(^\t)',null) RECORD_TITLE,
Can anyone assist with this issue.
Kind Regards,
Cecil S.