Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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

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

Hello,

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:

     CUST_NO|ADDR_LINE_1|CITY|ZIP
     1234|1 HIGH ST|CHICAGO|991234
     4567|"PACIFIC VIEW",ATLANTIC HEIGHTS|NEW YORK|980000
     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>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016