CSV File Input Problem for Word Wrap/Carriage return - PERL

Highlighted
One Star

CSV File Input Problem for Word Wrap/Carriage return - PERL

I am receiving an error when I run a job where the input file has string entries in "" with a word wrap/carriage return. I have attached an example of a text string that has the cariage return and a sample of the error I receive "A problem has happened parsing the following input line ====". Is there a way to fix this without manually changing the input file in excel.
Employee

Re: CSV File Input Problem for Word Wrap/Carriage return - PERL

Hello Rodney,
The problem you described is "expected". I mean that we currently do not support embedded new lines in a column. We should. The difference between tFileInputDelimited with and without the "CSV option", is the way the line is parsed, not the way the line is read from the filehandle.
I've read once again the Text::CSV_XS, and we could enhance the way lines are read from the CSV file by using:
$colref = $csv->getline ($io);

btlink

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download