Archives of the TeradataForum

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

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

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>>