0 - 2 of 2 tags for carriage returns

I need to export file with certain fields. Where one of coulmn data has a CR.
For eg:
 record1 aaa      bbb       ccc
 record2 ddd      eee       ffff 
The spaces between the aaa bbb represents the New Line Char..

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