Excel file with ALT + ENTER

One Star

Excel file with ALT + ENTER

Hi,
I got a problem to integrate an Excel file with a cell containing a line return (LF).
TOS doesn't integrate the line. When i pass in debug mode, i see a partial row with only fields before this famous cell.
Any idea ?

I'm using TOS 5.3.1.
One Star

Re: Excel file with ALT + ENTER

Are you able to downgrade the file from excel to CSV? Then use tFileInputDelimited? Converting from excel to a CSV file will save you from several excel related headaches.
One Star

Re: Excel file with ALT + ENTER

It's not ideal, but why not ?
I tried but i still have the same problem, Talend splits the line.
The "ALT ENTER" appears as a LF when i open the file with an editor.
In TOS, i try to change the default line separator to CRLF ("\r\n"), but it doesn't work.
Seventeen Stars

Re: Excel file with ALT + ENTER

Hi, I have checked this and in TOS 5.3.0 the tFileInputExcel component does not have any problems with a cell content containing line breaks.
One Star

Re: Excel file with ALT + ENTER

Thks !
Effectively, with a few ohter tests, it works.
But, the data preview is a bit confusing.