Archives of the TeradataForum
Message Posted: Thu, 05 May 2016 @ 21:51:11 GMT
<-- 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:
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|