I am trying to manipulate the following field and use a REGEXP_REPLACE() function to remove carriage returns and new lines. I don’t know how to annotate the ‘\r’ return properly in the expression along with other characters. Could you please let me know how it can be done.

use CHR(13) for carriage return CHR(10) for newline.