carriage returns and Line feeds

Database
Enthusiast

carriage returns and Line feeds

Hi ,

I am trying to run a query through a macro in unix,but my data in one of the teradata columns have carriage returns and line feeds.

I tried all possible combinations of the below , but nothing seems to be working on my data.

CHR(9)-Tab key = '09'XC
CHR(10)-Enter key = '0A'XC
CHR(13)- Carriage Return = '0D'XC

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

can any body help me to get rid of these from my query.

--Mora
1 REPLY
Enthusiast

Re: carriage returns and Line feeds

Look at the Oracle UDFs that are available for download. There's an oReplace UDF that will search a string for a given value and replace it with another. That might work better.