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