put " ' " in front of each number (vb)

Posted on 2006-11-16
Last Modified: 2010-04-16
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.

Question by:pratikshahse
  • 2
LVL 35

Expert Comment

ID: 17962517
stringName = "'" & stringName.Replace(",", "'.'") & "'"
LVL 35

Expert Comment

ID: 17962519
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

Expert Comment

ID: 17963745
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) & "'"
            strNew = strNew & arrString(i) & "','"
      end if

msgbox strNew

Accepted Solution

kumar_jac earned 250 total points
ID: 17964781

  You can achive this in ONE line as follows.

just copy and paste this

string a = "0000000,1111111,2222222,3333333"
 a = "'" + a.replace("," ,"','")   + "'"


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# code editing and collaboration 3 134
Not needed 13 119
Modify a small python script 19 116
Android development question 2 54
I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question