Thai language (File Reader , Excel Reader , CSV Reader)

[sauven]

I loaded Excel files with Thai into Knime. Thai was shown correctly in Excel, but Excel Reader could not display correctly. All Thai characters are shown as ❏ ❏ ❏ ❏.

Anyone has similar experience on Asian languages? do you have any suggestion?

[mlauber71]

@sauven welcome to the KNIME forum. Typically this might have to do with the character settings in the file readers. You might have to set them to utf-8 or even -16

Workflows: Utf-8 – KNIME Hub

And also make sure the KNIME workspace has these settings:

Why does the xpath node get incorrect data in the Indian language?

I changed the HTML parsing and retrieving part to some Palladian nodes and used your XPath definition and now it might work (although I cannot read the words). Maybe you want to check if this is what you need. Make sure you use UTF-8 as encoding. [image] [image] [image] [image] [image] kn_example_xpath_indian_words.knwf (198.0 KB)