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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch