导出CSV下划线时，OpenOffice会替换为"+ AF8-"， [英] OpenOffice when exporting CSV underscores are replaced with "+AF8-"

问题描述

我在Open Office上遇到问题.我正在尝试将某些文件导出为CSV文本，并且似乎下划线和其他一些字符可能已被替换.例如，我在文本编辑器中创建了此文件，并将其另存为test.csv:

I'm having issues with a Open Office. I'm trying to export some files as CSV text and it appears that underscores and perhaps some other characters are being replaced. For instance, I created this file in a text editor and saved it as test.csv:

"this_value","is_replaced"

然后我将文件作为电子表格打开到Open Office中.看起来不错.然后，我将其另存为名为test-export.csv的新CSV文件.当我在文本编辑器中打开新文件时，下划线将替换为"+ AF8-"，而逗号将替换为制表符.

I then opened the file into Open Office as a spreadsheet. It looked fine. Then I saved it as a new CSV file named test-export.csv. When I open the new file in a text editor, the underscores are replaced with "+AF8-", and the comma is replaced with a tab.

this+AF8-value  is+AF8-replaced

此更改使文件对于我的目的无用.知道是什么原因造成的吗?

This change makes the file useless for my purposes. Any idea what is causing this?

推荐答案

显然，当您将CSV文件导入Open Office时，引起了该问题.导入时，您可以选择要使用的字符集.我应该使用UTF-8时使用UTF-7.当我使用UTF-8导入时，它将按预期保存文件.

Apparently the problem is caused when you import the CSV file into Open Office. When you import it you have a choice which character set to use. I used UTF-7 when I should have used UTF-8. When I import using UTF-8, it then saves the file as I expect it should.

这篇关于导出CSV下划线时，OpenOffice会替换为"+ AF8-"，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！