Quoted qualifiers in TPT

Tools & Utilities

Quoted qualifiers in TPT

Hi,

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"

2 REPLIES
Highlighted
Teradata Employee

Re: Quoted qualifiers in TPT

Please refer to this thread:

https://forums.teradata.com/forum/tools/tpt-script-to-load-data-with-embedded-qualifiers

Embedded quotes must be escaped.

-- SteveF

Re: Quoted qualifiers in TPT

Thanks!