Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 May 2005 @ 13:40:48 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

From:   Dempsey, Mike

What are you wanting the data to look like?

a) One long string with no carriage returns?

b) Formatted data for Windows?

I think you will find that it contains Carriage Returns (x'0D') but not Line feeds (x'0A').

If you want 'a)' you would simply have to remove all x'0D' characters.

If you want 'b)' you would have to convert all x'0D' characters to x'0D0A' strings.

If you want to do this in SQL you would have to use a UDF - I think there is a 'replace' function in the set of UDFs available from Professional Services.

Many editors (Notepad) will automatically do the latter for you when you open the file. (although it might not save it that way.)

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023