Archives of the TeradataForum

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

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

<-- 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>>