Remove All carriage returns and line feeds from a column

[ccotton333]

Hey Folks,

I'm trying to remove all carriage return and line feeds from a column in teradata V2R6. I'm using the below syntax:

TRIM(BOTH '0A'XC FROM TRIM(BOTH '0D'XC FROM field_name))

However, this doesn't seem to remove the characters as it should. I have also tried:

TRIM(BOTH '0D'XC FROM TRIM(BOTH '0A'XC FROM field_name))

This returns the same results. Does anyone know how to make this work properly?

 

[mpramods]

Can you copy and paste the data in your column, so that we can see how the data looks like.

Cheers,
Pramod