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