You can translate the question and the replies:

Ellipsis converting to a Special Character while downloading data from Denodo

We are using Denodo VDP 7.0. Our data has a … (Ellipsis) symbol in a row. The problem exists when the data is downloaded from Denodo or extracted from Denodo. Below is the problem. When we try to extract data from a Denodo view, the data gets changed into a special character (ââ) , when we see it in Excel. When the data is opened using a notepad, the data looks fine. Has anyone faced similar issue or if you can help.
19-01-2022 05:32:59 -0500

1 Answer

Hi, I also came across a similar situation when trying to access the exported file from Denodo Platform using the third party tool (Excel). This happens because the Virtual DataPort **generates** the result file with **UTF-8** encoding whereas the third party tool (Excel) was unable to detect UTF-8 encoding. Hence, in order to avoid it, you could manually change the default **character encoding** of the third party **tool**(like Excel) to **UTF-8** for accessing the exported files. Hope this helps!
Denodo Team
21-01-2022 06:45:08 -0500
You must sign in to add an answer. If you do not have an account, you can register here