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?
If all the fields are quoted, why do you need to escape the delimiter (inside the quotes)?
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.