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 = '|',
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..
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.