blocks|key|3004881|text|用等号作为值的前缀|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3004882|="x",="y",="-z"|code-block|syntax|javascript|3004883|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Prefix the values with equals signs

<pre><code>="x",="y",="-z"
</code></pre>

blocks|key|287949|text|您的问题是，通过使用CSV扩展，您迫使Excel使用其非常严格的CSV约定来解释文件，这通常会与您尝试执行的操作相冲突，除非CSV文件最初是由excel创建的。导入此CSV文件的最简单、最可靠的方法是将其重命名为TXT文件，然后使用excel中的导入功能以所需的方式强制列。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|287950|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Your problem is that by using the CSV extension, you are forcing excel to interpret the file using its very strict CSV conventions, and this will often go against whatever it is you're trying to do unless the CSV file was originally created by Excel. Your easiest, and most reliable method of importing this CSV file, is to rename it to a TXT file, and then use the import function in excel to coerce columns in exactly the way you want.

blocks|key|3218690|text|我在Excel2003中尝试了您的第一个示例，可以重现您的#NAME错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3218691|我的解决方案是打开文本文件，并在导入向导(第3页)中将第3列指定为"+text“-同时选择正确的分隔符和文本限定符(第2页)。|3218692|不需要对文本文件进行更改。|3218693|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I tried your first example in Excel 2003 and could reproduce your #NAME eror.

My solution was to open the text file and to specify the 3rd column as "Text" in the import wizard (3rd page) - along with choosing the correct delimiter and text qualifier (2nd page).

No changes needed to the text file.

blocks|key|288861|text|使用“Excel”>“导入”和双击.CSV文件是完全不同的。使用不同的解析器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|288862|基于上面的评论，我认为在'%2B‘或'-’符号前加上一个空格对于双击.CSV文件的情况是有效的。所以我的文件现在包含了例如|offset|length|style|BOLD|288863|"+%2B14";"+-Foo"|code-block|syntax|javascript|288864|entityMap^0|0|B|H|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

There is a complete difference in using Excel > Import and double-click a .CSV file. Different parsers are used. 

Based on the comments above, I figured out that prepending a space before a '+' or '-' sign works for the double-click .CSV file case. So my file now contains e.g.

<pre><code>" +14";" -Foo"
</code></pre>

blocks|key|291292|text|我更喜欢在转换过程中直接解决这样的问题，通过给出正确的列格式，例如:对应该包含操作符号的列使用文本格式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|291293|​|291294|📷|atomic|offset|length|291295|291296|请查看此详细帖子：http://ask.osify.com/qa/854|291297|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/869f8fa156929f2ab6ff35e06c8b33e5.png|imageAlt|1|LINK|MUTABLE|url|http://ask.osify.com/qa/854^0|0|0|0|1|0|0|0|9|R|1|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|11|8|@]|9|@$G|12|H|13|1|14]]|A|$]]|$1|I|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|16|8|@]|9|@$G|17|H|18|1|19]]|A|$]]|$1|L|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]|U|$5|V|P|W|A|$X|Y]]]]

I would prefer to solve such problem directly during the conversion, by giving the right column format, example: use Text format for the column that should contain operation sign:

<a href="https://i.stack.imgur.com/LR2OG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LR2OG.png" alt="Text format on the column"></a>

Check this detail post: <a href="http://ask.osify.com/qa/854" rel="nofollow noreferrer">http://ask.osify.com/qa/854</a>

blocks|key|3005035|text|查找并替换具有'+%2B的每个%2B实例|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3005036|开头的单引号和空格应该可以消除任何%2B、-或=。|3005037|entityMap^0|7|3|D|1|0|H|1|J|1|L|1|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|I|$]]

Find and replace every instance of
<code>+</code>
with
<code>' +</code>

A single quote and space at the beginning should cancel out any <code>+</code>, <code>-</code>, or <code>=</code>.

blocks|key|3218787|text|您还需要将1.5个数字转换为1,5个字符串，这样它们就不会更改为date类型值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3218788|对于%2B-=我使用空格方法“%2B...”-不是很好，但对我的任务来说已经足够了。|3218789|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You also will need to transform 1.5 numbers to 1,5 strings, so they don't changed to date type values.

For + - = I use space method " +...." - not great, but for my task was enough.

I have a csv file with contents:

<pre><code>"x","y","-z"
</code></pre>

When I import it I get:

<img src="https://i.stack.imgur.com/DUAMW.png" alt="alt text">

How can I bypass this conversion?

Update

If you try:

<pre><code> "x","y",="-z,a"
</code></pre>

The ",a" is not imported.

If you put a space in front:

<pre><code> "x","y",=" -z"
</code></pre>

or

<pre><code> "x","y"," -z"
</code></pre>

it will work fine

Bypass excel csv formula conversion on fields starting with + or -

我有一个包含以下内容的csv文件："x","y","-z"当我导入它时，我得到：​​如何绕过此转换？更新如果你尝试：   "x","y",="-z,a"不导入"，a“。如果在前面放一个空格：   "x","y",=" -z"或   "x","y"," -z"它会工作得很好

问绕过以+或-开头的字段的excel csv公式转换
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问绕过以+或-开头的字段的excel csv公式转换EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问绕过以+或-开头的字段的excel csv公式转换
EN