EscapeTextDelimiter option not working in TPT

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Enthusiast

EscapeTextDelimiter option not working in TPT

Hello All,

 

We are exporting data through TPT and we need to escape both Quotes as well as delimiters in data because the data contains both quote and delimiter character.So to avoid any conflicts we are planning to escape both the enclosure and delimiter characters in the data.

 

The options we are setting in the dataconnector operator are:

 

VARCHAR OpenQuoteMark = '"',
VARCHAR CloseQuoteMark = '"',

VARCHAR TextDelimiter     = '|',

VARCHAR QuotedData='Yes',

VARCHAR EscapeQuotecharacter='\'

VARCHAR EscapeTextDelimiter='*'

 

 

The quotes are coming properly,so are the delimiters and the quotes in data are escaped properly.But the delimiters character '|' when present in the data cannot be escaped.Is there anything wrong with the understandiing or the usage?

Just to add the version of TPT is 15.0 and Teradata is 13.0.Please help..

 

 

1 REPLY
Teradata Employee

Re: EscapeTextDelimiter option not working in TPT

Most of these parameters are more for importing data from a file rather than exporting to a file. You need to determine what the target system can accept and then tailor the output to fit. Do you need to quote data fields? If you don't then any quotes are treated as data. You might just need to choose an appropriate delimiter which may have to be multiple characters.