How to remove new line characters from the end of a field in Teradata

[indra91]

Hi,
We have a table where we have 'New Line Characters(Carriage Return)' at the end of many fields which is unreadable by the downstream system.We need to remove all the 'New Line Characters' from the end of all the fields.Can we use trim function/UDF to achieve this?Any other effective way to achieve this?

Regards,
Indranil Roy

[David_Roth]

oreplace(column, chr(12),'')

or chr(11) depending on if you have CR or LF

Thanks

Dave

[indra91]

@David
Just curious if the character is present at the end can we use trim function for the same?

Regards,
Indranil

[dnoeth]

RTrim(col, '0A0D'xc)

removes all trailing Carriage Returns or Line Feeds.