Archives of the TeradataForum

Message Posted: Mon, 02 Nov 2009 @ 13:46:14 GMT

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

Thanks Victor. No my two issues are two separate things. The reason I need to figure out an escape character is that I have feeds from a different system which automatically uses a \ as an escape character. So when it is outputting data, if it finds a pipe (|) in the middle of a field, it inserts a \. Obviously it does the same thing if it finds a \, it just makes it \\. I know I can write a sed program to do the replace, but just thought it would be easier if there were an escape functionality in the mload program itself. I looked through the mload manual and searched the knowledge base on the Teradata site, but couldn't find one.

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