<div>
stringName = &quot;'&quot; &amp;&nbsp;stringName.Replace(&quot;,&quot;, &quot;'.'&quot;) &amp;&nbsp;&quot;'&quot;
</div>


stringName = "'" & stringName.Replace(",", "'.'") & "'"

<div>
sorry typeo<br />
<br />
stringName = &quot;'&quot; &amp;&nbsp;stringName.Replace(&quot;,&quot;, &quot;','&quot;) &amp;&nbsp;&quot;'&quot;<br />
<br />
so if you replace the comma with a ',' it will do everything except for the start and finish - so you can then put in a single inverted comma
</div>


sorry typeo

stringName = "'" & stringName.Replace(",", "','") & "'"

so if you replace the comma with a ',' it will do everything except for the start and finish - so you can then put in a single inverted comma

<div>
Here is a script that is one better.... It'll add the ' at the beginning and end of the string, as well as around the ,<br />
<br />
strOld = &quot;0000000,1111111,2222222,3<wbr />333333&quot;<br />
arrString = Split(strOld, &quot;,&quot;)<br />
For i=0 to UBound(arrString)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if i= 0 then<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;strNew = &quot;'&quot; &amp;&nbsp;arrString(i) &amp;&nbsp;&quot;','&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;elseif i = UBound(arrString) then<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;strNew = strNew &amp;&nbsp;arrString(i) &amp;&nbsp;&quot;'&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;strNew = strNew &amp;&nbsp;arrString(i) &amp;&nbsp;&quot;','&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end if<br />
Next<br />
<br />
msgbox strNew
</div>


Here is a script that is one better.... It'll add the ' at the beginning and end of the string, as well as around the ,

strOld = "0000000,1111111,2222222,3333333"
arrString = Split(strOld, ",")
For i=0 to UBound(arrString)
      if i= 0 then
            strNew = "'" & arrString(i) & "','"
      elseif i = UBound(arrString) then
            strNew = strNew & arrString(i) & "'"
      else
            strNew = strNew & arrString(i) & "','"
      end if
Next

msgbox strNew

<div>
<div class="content wysiwyg-content">
I have a string <br />
<br />
string = 0000000,1111111,2222222,33<wbr />33333<br />
<br />
I want to put &quot;&nbsp;' &quot;&nbsp;in front of each number so the string should look like<br />
<br />
string = '0000000','1111111','22222<wbr />22','33333<wbr />33'<br />
<br />
<br />
each number in the string is 7 digits long. <br />
<br />
How do i do this.<br />
<br />
Thanks
</div>
</div>


I have a string 

string = 0000000,1111111,2222222,3333333

I want to put " ' " in front of each number so the string should look like

string = '0000000','1111111','2222222','3333333'


each number in the string is 7 digits long. 

How do i do this.

Thanks

put &quot; ' &quot; in front of each number Asp.net (vb)

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

put &quot; ' &quot; in front of each number Asp.net (vb)

put " ' " in front of each number Asp.net (vb)