close

i need to use commas, semi-colons, and double quotes in a string

users.put(quot;bdubosequot;,quot;1 Barbara Dubose bdubosequot;);

i figured out that i can use quot;quot;quot; and get a double quote but when i try quot;,quot;
for the comma i get an error correction message that offers to correct the
error and drop the , and a different error for quot;;quot; w/o a correction.

thanks

This string concatenates fine on my Excel 97........what version Excel are
you using?

=quot;aquot;amp;quot;,quot;amp;quot;bquot;amp;quot;;quot;amp;quot;cquot;
results to....
a,b;c

give us your actual formula that does not work..........

Vaya con Dios,
Chuck, CABGx3quot;bob alouquot; wrote:

gt; i need to use commas, semi-colons, and double quotes in a string
gt;
gt; users.put(quot;bdubosequot;,quot;1 Barbara Dubose bdubosequot;);
gt;
gt; i figured out that i can use quot;quot;quot; and get a double quote but when i try quot;,quot;
gt; for the comma i get an error correction message that offers to correct the
gt; error and drop the , and a different error for quot;;quot; w/o a correction.
gt;
gt; thanks

=quot;users.put(quot;quot;bdubosequot;quot;,quot;quot;1 Barbara Dubose bdubosequot;quot;);quot;

will output

users.put(quot;bdubosequot;,quot;1 Barbara Dubose bdubosequot;);

if you want quot; to appear in a string you use it twice not three times. The ,
and ; doesn't need anything special.

quot;bob alouquot; wrote:

gt; i need to use commas, semi-colons, and double quotes in a string
gt;
gt; users.put(quot;bdubosequot;,quot;1 Barbara Dubose bdubosequot;);
gt;
gt; i figured out that i can use quot;quot;quot; and get a double quote but when i try quot;,quot;
gt; for the comma i get an error correction message that offers to correct the
gt; error and drop the , and a different error for quot;;quot; w/o a correction.
gt;
gt; thanks

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()