Solved

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

Posted on 2006-11-16
4
244 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 250 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
A short article about problems I had with the new location API and permissions in Marshmallow
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now