Ctrl-A delimiter with TPT Export.

Tools
Enthusiast

Ctrl-A delimiter with TPT Export.

Hi, 

I want to use CTRL-A as delimiter for TPT exports, I would like to know how to specify this in the TPT script.

Thanks & Regards,

Srivignesh KN

2 REPLIES
Teradata Employee

Re: Ctrl-A delimiter with TPT Export.

There is an attribute for the DataConnector operator (I think still undocumented) called TextDelimiterHex.

Set that to '0A' and the DC operator should write out that character as the field delimiter.

-- SteveF
Enthusiast

Re: Ctrl-A delimiter with TPT Export.

Thank you Steve, 

Alternatively, i tried specifying CTRL-A in the Textdelimiter attribute by giving CTRL-V CTRL-A through vi editor and this is able to export data with CTRL-A delimiter.

VARCHAR TextDelimiter = ^A 

Regards,

Srivignesh KN