How to remove line feed and Carriage return from clob column

Summary:

How to remove line feed and Carriage return from clob column, without using Translate function and Exclude Line Feed And Carriage Return for LOB option in properties

Can any one help me?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):