TPT - Handling Delimited File with Embedded CR\LF in field

Tools
Enthusiast

TPT - Handling Delimited File with Embedded CR\LF in field

Hi,

I have a file which is comma delimited with fields in double quotes and some comment fields have embedded CR/LF within the fields. How do I preserve the CR\LF and load the file using TPT Load Operator? I keep getting the error - Delimited Data Parsing error: Too few columns in row nnnnn because it treats the CR\LF within the field as a new row.

Here are my varchar attributes set:

ATTRIBUTES

(

"FileName" = 'temp.csv', 

"Format" = 'DELIMITED', 

"OpenMode" = 'Read', 

"DirectoryPath" = 'C:\Users\xxxxx\Desktop', 

"IndicatorMode" = 'N', 

"TextDelimiter" = ',',

"CloseQuoteMark" = '"',

"OpenQuoteMark" = '"',

"QuotedData" = 'Y'

)

2 REPLIES

Re: TPT - Handling Delimited File with Embedded CR\LF in field

Hi,

I am also facing similar issue, my delimiter is "|" and it is failing with Delimited Data Parsing error: Too few columns in row 1.

When I converted this to fixed width, same file is loaded to my target table with the new line replaced with a space.

Am using - Teradata Parallel Transporter Version 14.10.


Teradata Employee

Re: TPT - Handling Delimited File with Embedded CR\LF in field

Re: Thompson: you did not indicate which version of TPT you are running.

TPT versions prior to 15.10 do not support embedded CR/LF, even in quoted strings.

-- SteveF