How to remove the spaces in a string Ex: "Welcome to
QTPWorld" ?
Answers were Sorted based on User's Feedback
Answer / vinay
Str = Welcome to QTP World
Replace(Str," ","")
Result= WelcometoQTPWorld
Is This Answer Correct ? | 27 Yes | 0 No |
Answer / krishna
Str="Quick Test Pro"
R=Replace(Str," ","")
msgbox R
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / vasudha
Dim str
str="welcome to qtp"
arr=split(str," ")
For i=0 to Ubound(arr)
abc=abc&arr(i)
Next
print abc
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / mithuna reddy
Dim str,arrsplit,arrjoin
str = "Welcome to QTP World"
arrsplit = Split(str," ")
arrjoin = Join(arrsplit,"")
MsgBox arrjoin
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / lak
Mahe answer is will work only traling and leading the
spaces from a string.But middle spaces can not be removed
from a string.
agree with vinay ,vasudha
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ranni
Trim function will not work,it cannot remove spaces in between words
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sowjanya
Msgbox Replace("wellcome to qtp world"," ","")
OR
str= "Wellcome to qtp world"
arr=Split(str," ")
for i=0 to Ubound(arr)
abc=abc&arr(i)
next
msgbox abc
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vishnu
Str = "Welcome to QTPWorld"
Sp1=Split(str)
For i=0 to ubound(Sp1)
temp=temp&Sp1(i)
Next
print temp
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mahesh
Ex::
X="Welcome to QTP World"
Y=trim(X)
Msgbox Y
O/p::WelcometoQTPWorld
Is This Answer Correct ? | 4 Yes | 29 No |
How to assign a date value to a variable?
What is the difference between a dictionary and an array?
what is descriptive programming in QTP and what is environment variable in QTP? where we store and what is its use?
How will you get the natural logarithm of the given number in vbscript?
What is vbscript language used for and which earlier language is it modeled upon?
What is the purpose of on error resume next statement?
How will you check that a variable is an array in vbscript?
Explain sga memory structures?
I want to import the sheet from the Excel to the Datatable using VB Script. I used the Syntax as 'Datatable.ImportSheet "Filename","SourceSheet","Destinat ionSheet" Ex: Datatable.ImportSheet "D:\Data1.xls","Sheet1","Global" Qtp producing run time error,How I can solve the problem
Write a program to display the numbers in the below format using for loops? 1 2 3 4 5 6 7 8 9 10 11 12 and Write a program to display the numbers in the below format using for loops. 1 2 3 4 5 6 7 8 9 10
What is the output of a + b in vbscript if a = 5 and b = 10?
Here in my automation tool, i am retreiving some values and i need to store this values in the excel. How can i achieve this?. We are using VBA as scripting language. please let me know if you require any further inputs.