I am having same issue of new line character within data in teradata.
How to replace new line character with space using any teradata select query?
Yes you can replace NEWLINE using the OREPLACE function in SELECT.
SEL OREPLACE(OREPLACE(yourcolumn , X'0d' , ' ') , X'0a' , ' ') yourcolumn
SEL OREPLACE(yourcolumn , X'0a' , ' ') yourcolumn