Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 May 2016 @ 21:51:11 GMT

  <Prev Next>  
Next> Last>>  

Subj:   TPT - can it handle double quotes
From:   Anomy Anom

<-- Anonymously Posted: Thursday, May 05, 2016 17:37 -->


I am looking for advice regarding loading a delimited file that has double-quotes within the data.

Reading the TPT parsing rules I think it should be able to process this record but it fails.

Using TPT V14.0 I have a recurring problem where a delimited file load hits a 'fatal error'.

This is because one of the columns contains a string which is contained in double-quotes. This is typically part of the house name in an address and is a frequent problem.

This example, delimited by | showing the header fails:

     1234|1 HIGH ST|CHICAGO|991234
     7890|2 MARKET ST|CHICAGO|951234

The error message is "Delimited Data Parsing error: Delimiter did not immediately follow close quote mark in row 3 column 2".

i.e. It cannot handle row 3 as it is looking for the delimiter immediately after "PACIFIC VIEW" and not after ATLANTIC HEIGHTS.

Note, it has a double-quote character and not two single quotes.

I have tried various VARCHAR options including QuotedData ='No' but nothing makes any difference.

I have to run a prior process to remove the double-quotes. It then works.

Any advice appreciated

thank you

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020