google docs电子表格导出:如何从时间，日期中删除撇号 [英] google docs spreadsheet export: How to remove apostrophe from times, dates

问题描述

我正在从Google文档中将电子表格导出为CSV，并且每个日期和时间值前面都带有撇号(').这真的很烦人，因为OpenOffice似乎无法在电子表格编辑器中查找/替换这些内容.

I'm exporting a spreadsheet from Google Docs as CSV, and there are apostrophe's (') prepended to each date and time value. This is really annoying as OpenOffice doesn't seem to be able to find/replace these in the spreadsheet editor.

我可以通过将CSV文件作为文本打开并用这种方式替换字符来解决此问题，但是似乎必须首先有一种方法来防止出现此问题.有人知道解决此问题的方法吗?(在OO文件导入期间删除它们也是一种可以接受的解决方案.)

I could solve the problem by opening the CSV file as text and replacing the chars that way, but it seems like there has to be a way to prevent the issue in the first place. Anyone know of a way to fix this? (Removing them during the OO file import would also be an acceptable solution.)

推荐答案

事实证明CSV文件本身在数据中没有撇号，但是它们是在导入期间由OpenOffice Calc添加的.选中标记为检测特殊数字"的选项阻止了此修改，但随后将值转换为可以在电子表格视图中处理的特定格式.仍然不是理想的解决方案，但是很明显，问题集中在OpenOffice Calc而非Google Docs上.

It turns out the the CSV file itself didn't have the apostrophes in the data, but they were being added by OpenOffice Calc during the import. Checking the selection marked "Detect special numbers" prevented this modification, but then converted the values to specific formatting that can be handled within the Spreadsheet view. Still not an ideal solution, but clearly the issue centers on OpenOffice Calc rather than Google Docs.

这篇关于google docs电子表格导出:如何从时间，日期中删除撇号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！