All Forums Tools
TDRookee 2 posts Joined 10/14
01 Oct 2014
Quoted qualifiers in TPT

I have a pipe demimited file which looks like below and also some fields are starting and ending with quotes. But as you see the highlighted part there is a qualifier with in a text field and my TPT script is not able to parse the file.
I am using Teradata 14
Is there a way that I can skip the qualifier and make my TPT script working? Can EscapeTextDelimiter works in this scenario?
Thanks in advance!
|0.00|0.00|"999"|"xyzhjh" abc"|"~01"|"00000000000"

feinholz 1234 posts Joined 05/08
01 Oct 2014

Please refer to this thread:
Embedded quotes must be escaped.


TDRookee 2 posts Joined 10/14
01 Oct 2014


You must sign in to leave a comment.