格式化行，以便最终得到="08075" [英] Format line so that I end up with ="08075"

问题描述

我在此行中放几行(双引号)，以便最后将="08075"粘贴到我的excel工作表中?该行是:

How many " (double quotes) do I put around this line so that I end up with ="08075" being pasted into my excel worksheet? The line is:

Response.Write vbTab & ResultSet(8,r)

我需要在ResultSet(8，r)之前用单引号将'='加上单引号，在...之后用双引号括起来...

I need and '=' sign with a single quote before the ResultSet(8,r) with a closing double quote after... I tried:

Response.Write vbTab & "="" & ResultSet(8,r) & """

但是那行不通，再加上其他几个行列却行不通，引号的数量总是吸引我，因此，如果有人想给我关于这条规则的一般经验，我将不胜感激.

but that didn't work, plus a couple others but that didn't work, the number of quotes thing always gets me so if someone wants to give me a general rule of thumb on this one I would really appreciate it.

推荐答案

要在VBScript中的字符串中获取文字双引号(")，您需要使用两个双引号("").因此，对于您的示例:

To get a literal double quote (") inside of a string in VBScript, you need to use two double quotes (""). So for your example:

Response.Write vbTab & "=""" & ResultSet(8,r) & """"
'                      ^   ^                    ^  ^ These delimit the string
'                        ^^                      ^^  These create literal quotes

这篇关于格式化行，以便最终得到="08075"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！