如何将csv文件编码转换为utf-8
是否可以将 iso-8859-13
编码的csv数据转换为 UTF-8
?
Is it possible to convert csv data that has iso-8859-13
encoding to UTF-8
?
我的旧系统没有 UTF-8
编码,它只使用 iso-8859 -13
。我需要导入的系统没有 iso-8859-13
,但是同时具有 UTF-8
和 UTF-16
。如果我尝试使用 iso-8859-13
以外的编码打开csv文件,则无法识别某些符号。如果我尝试将此类文件导入新系统,则会出现错误,我编码错误。我只能使用 windows-1252
导入它,但随后会导入无法识别的符号。如何将其转换为普通编码,例如 UTF-8
?
My old system does not have UTF-8
encoding, it uses only iso-8859-13
. The system that I need to import to does not have iso-8859-13
, but has both UTF-8
and UTF-16
. If I try to open the csv file with an encoding other than iso-8859-13
, then some symbols are not recognized. If I try to import such file into the new system, it gives an 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
?
我只能使用文本编辑器进行转换。我用 iso-8859-13
编码打开了csv文件。然后使用 utf-8
创建空csv文件。然后简单地将所有内容从一个csv复制到另一个。然后我可以将它导入新系统。
I was able to convert simply using text editor. I opened csv file with iso-8859-13
encoding. Then created empty csv file with utf-8
. Then simply copied everything from one csv to another. Then I could import it into new system.
以前我试过用libreoffice做这个,但出于某种原因它会用 iso-8859保存-13
编码。
Previously I tried to do this with libreoffice, but for some reason it would save with iso-8859-13
encoding.