Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2006-11-16
4
Medium Priority
?
251 Views
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.

Thanks
0
Comment
Question by:pratikshahse
  • 2
4 Comments
 
LVL 35

Expert Comment

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

Expert Comment

by:Raynard7
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
0
 
LVL 8

Expert Comment

by:deadite
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) & "'"
      else
            strNew = strNew & arrString(i) & "','"
      end if
Next

msgbox strNew
0
 
LVL 5

Accepted Solution

by:
kumar_jac earned 1000 total points
ID: 17964781


Hi,
  You can achive this in ONE line as follows.

just copy and paste this

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



0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

810 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