Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove the spaces in a string
Ex: "this is apple"
- 5 Answers
- 16421 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / shashank shekhar raj
Hai,
Try this it's much easier
x="This is apple"
x=replace("This is apple"," ","")
MsgBox x
REPLACE is function in which i replace whitespace (" ")
by no space ("")
| Is This Answer Correct ? | 25 Yes | 1 No |
Post New Answer View All Answers
Sub link() Dim k As Integer Dim rand As Integer Dim URL As String Dim foldernum As Integer Dim folderstring As String Dim filenum As Integer Dim filestring As String k = 1 'for AC Numbers For i = 11 To 40 foldernum = 0 foldernum = 1000 + i folderstring = CStr(foldernum) folderstring = Mid(folderstring, 2, 3) folder = "ac" & folderstring 'folderstring = Sheets(2).Cells(i, 1) ' for Number of Random files For j = 1 To 10 rand = Int(Rnd * (200 - 1) + 1) filenum = 0 filenum = 1000 + rand filestring = CStr(filenum) filestring = Mid(filestring, 2, 3) 'URL = "http://ceobihar.nic.in/PSCDROM/ac" & folderstring & "/i" & folderstring & "0" & filestring & ".pdf" URL = "http://www.elections.tn.gov.in/pdfs/dt1/" & folder & "/" & folder & filestring & ".pdf" ' URL =http://www.wb.nic.in/wbeco/EROLLS/PDF/English/A001/a0010105 .pdf Cells(k, 1) = folderstring Cells(k, 2) = folder Cells(k, 3) = filestring Cells(k, 3) = URL k = k + 1 Next j Next i End Sub plz define it
Out of the different type of operators, which are evaluated first and last in the vbscript language?
How can you create a file object to work with the files in the vbscript language?
Which data type/types are supported by vbscript language and what are their specialties?
Which function allows you to instantiate an object given its programmatic identifier or progid?
How will you get the smallest subscript of an array in vbscript?
Mention what if you do not specify anything when you call a procedure?
what is the features of visual basic?
Can someone please tell me what poor design in a relational database (not the layout or style) is and how it can be avoided? PLEASE...im desperate.
give me any information abou vb script books learn quckly
Mention what is vbscript procedures?
write a function to read the items from combobox of Flight reservation & save in excel (QTP)??
Which operator can be used to change the value of the operand or change the state of the condition?
What is the purpose of on error resume next statement?
What is the use of the formatdatetime function in the vbscript language?
