Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi,
I am trying to export a dataset to csv file on sharepoint folder. The data contains special characters e.g. 'å'.
But when I run the export recipe the value in csv is exported as ''BredbÃ¥nd' instead of ''Bredbånd' .
Can someone help me how to fix this.
Can you clarify how exactly you are viewing the resulting CSV file? Is it in DSS, or using some other software?
The fact that you see Ã¥ instead of å would mean that you're viewing UTF-8 encoded data as ISO-8859-1, for example. The å character is encoded with two bytes in UTF-8: 0xC3 0xA5. Those two bytes are à and ¥, respectively, in ISO-8859-1 (https://en.wikipedia.org/wiki/ISO/IEC_8859-1#Code_page_layout). Thus, it is likely that the CSV is correctly encoded with UTF-8, and whatever software you're using to view it is not correctly configured to read the data as UTF-8.
Thanks JuanE. The problem was with the sharepoint file. When I exported the file as excel instead of csv it worked.