topic Excel file with ALT + ENTER in Talend Studio

Excel file with ALT + ENTER

phil974 — Wed, 23 Oct 2013 20:19:06 GMT

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.

Re: Excel file with ALT + ENTER

Anonymous — Wed, 23 Oct 2013 20:32:01 GMT

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.

Re: Excel file with ALT + ENTER

phil974 — Wed, 23 Oct 2013 20:46:46 GMT

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.

Re: Excel file with ALT + ENTER

Anonymous — Wed, 23 Oct 2013 21:43:20 GMT

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.

Re: Excel file with ALT + ENTER

phil974 — Thu, 24 Oct 2013 12:25:08 GMT

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