write polish characters in an csv file

Hi all,
I am quite new in KNIME and I need your help.
I am working in a global team and I need to export my knime table to a csv file. The table contains special letters of Polish alphabet such as “ó”, “ń”, “ł” and when it is exported in a csv, I get a “?” instead of the letter. I have tried all the types of encoding.
Is there a way to overcome this?
Thank you in advance.

Hi @ChrMavrom

UTF-8 encoding should be sufficient in this case. If I use the symbols you describe, it’s written correctly to the csv file.

Input and output:

2 Likes

when i open it in an notepad, i can see the letters. when i open it using excel I only see ?.
Any advises?

You didn’t mention that :wink: Use the import function of Excel instead to ensure UTF-8 compatibility.

https://support.microsoft.com/en-us/office/opening-csv-utf-8-files-correctly-in-excel-8a935af5-3416-4edd-ba7e-3dfd2bc4a032

1 Like

Hi @ChrMavrom

I can confirm UTF-8 option @ArjenEX mentions generates Polish letters (small and capital ones) correctly. Please make sure to have Polish language installed for Excel (Office).
Happy KNIMEing,
Kaz

3 Likes