We are exporting data from Teradata using TPT using '|' as delimiter and double quotes(") as enclosure.The data has both doublequotes as well as '|' in the data.Can we escape both quotes as delimiters in the TPT export script?
Check out "EscapeTextDelimiter" and "EscapeQuoteDelimiter" in the TPT Reference Manual.
Can you please provide a sample row that is failing?
What version of TPT are you running?
Should not have to.
That is why I asked for a sample row that is failing, and the version of TPT, in case we had a bug that was fixed.