跳至內容
選單
此問題已被標幟
2 回覆
37462 瀏覽次數

is it possible to somehow convert csv data that has iso-8859-13 encoding to utf-8?

Old system, does not have utf-8 encoding, it uses only iso-8859-13. And OpenERP, does not have iso-8859-13, but have both utf8 and utf-16. If i try to open csv file with other encoding than iso-8859-13, then some symbols are not recognized. And if I try to import such file into OpenERP it gives error that I have wrong encoding. I can only import it using windows-1252, but then it will import with unrecognized symbols. What can I do to convert it to normal encoding such as utf-8?

頭像
捨棄
最佳答案

Hello,

with a simple text editor you can convert your file to utf:

http://notepad-plus-plus.org/

image description

OR for Linux look here:

http://superuser.com/questions/16672/how-can-i-convert-multiple-files-to-utf-8-encoding-using-nix-command-line-tools

頭像
捨棄
作者

Do you mean set encoding or convert? because where is an option to convert encoding? Also I use Linux, so what equivalent could do in linux as in gedit I don't see a way to convert encoding from one to another.

With notepad++ you can encode and convert. see updated image. But it is Windows application. I'm sorry... There must be something equivalent for linux too...

I found a Linux way. See my updated answer. I hope it works, I cannot try it...

作者

I was able to convert encoding simply creating new csv file with utf-8 encoding, then copying everything there. I previously tried something similar with libreoffice, but that didn't work.

最佳答案

I prefer to use Codelobster editor

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
3
6月 20
3622
1
11月 18
9157
11
2月 17
63331
2
3月 15
10635
4
11月 24
10835