Hallo forum,

ich import (successfully) an execl-file via ftp. I have no chance to change something on this file.
Then I start a transformation with Excel Input from the imported file. ... but there the trouble starts. The column-haeder contains things like that " 'somname ", there these stupid ' in ervery Header. If I remove that manually, the Excel Input works correctly ... and on some hand its to understand, that kettle can't handle this "open string".

Does anybody know a workaround in kettle, to remove these ' bevor getting into Excel Input? or to add an "closing" ' at the end of the column-header?

Thanxx