Hi,
I will give a sample SQL statement that will find the carriage return char by using the equivalent chr(10).
SQL> select instr('dsflkjdfldsdsf
2 dfdsfdsfd',chr(10)) from dual;

INSTR('DSFLKJDFLDSDSFDFDSFDSFD',CHR(10))
----------------------------------------
15

from here you can identify the position of the carriage return character
which you can then use to substitute with the blank character using other function such as SUBSTR, etc.

good luck.