CSV encoding inside input text file step on Kettle

Question

I am doing i simple input text file into Kettle Pentaho PDI 8.1.0. The file has several acceding char like "á" and it is a .csv file.

In the settings of the input text file step i set the encoding to ISO-8859-1. So when i go to "Show file content" button everything are correct.

But when i press the Preview rows so i can see the data separated into columns then i get error on all acceding chars and are replaced with ? So Mária becomes M�ria.

By using the word error i do not mean that kettle does not run the transformation but that the data are not correct.

Any Idea?

i can not provide sample data but it is normal data with special chars like what i am writing above. so i am loosing the characters — kyrpav, Jul 16 '18 at 08:33

score 0 · Answer 1 · answered Jul 19 '18 at 05:34

0

Your file is obviously not encoded in ISO-8859-1.

The Encoding field in the Content tab of 'Text file input' is used by the "Preview rows" button but not by the "Show file content" button.

Try another encoding.

answered Jul 19 '18 at 05:34

Gotti

1
2

score 0 · Answer 2 · answered Aug 24 '18 at 15:36

0

Try encoding cp866, hope it helps, or also you could try encoding with latin-1

answered Aug 24 '18 at 15:36

Roger Nieto

63
10

CSV encoding inside input text file step on Kettle

2 Answers2