How to return only alpha bate string from an string str =
"bibhu@#$%&das&*)(SUndar"
- 4 Answers
- 5511 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satishraja
str ="bibhu@#$%&das&*)(SUndar"
L=len(str)
For i=1 to l
x=left((right(str,l-i+1)),1)
If ASC(ucase(x))>=65 and ASC(ucase(x))<=90 then
Print x
End If
Next
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / usha
str="bibhu@#$%&das&*)(SUndar"
Set r = new regexp
r.pattern="[A-Z]"
r.global=true
r.ignorecase=true
Set a =r.execute(str)
msgbox a.count
For each t in a
msgbox t
Next
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pankaja yathindrakumar
'How to return only alphabate string from an string str = "bibhu@#$%&das&*)(SUndar"
str="bibhu@#$%&das&*)(SUndar"
for i=1 to len(str)
x=mid(str,i,1)
if Asc(x)>=Asc("A") And Asc(x)<=Asc("z") then
t=t&x
End If
Next
Msgbox t
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / indrani
str="bibhu@#$%&das&*)(SUndar"
Set r = new regexp
r.pattern="[A-Z]"
r.global=true
r.ignorecase=true
Set a =r.execute(str)
msgbox a.count
For each t in a
s1=s1+t
Next
msgbox s1
| Is This Answer Correct ? | 0 Yes | 0 No |
If else for do while select in vb script?
Hi Friends Rajendra this is bhavani prasad, iam working Hyderabad. i faced one problem with qtp recording mode i.e in my application there is 100 records first we click the first record that record will be jumped to next session and 99 records will there stop the recording and run the same script .Run this script qtp does not identify the records. So plz tell me what is the solution.
Diff between web table ,datatable and data base (QTP)
What is the main difference between function and sub-procedure?
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.
What are the properties of regexp object?
Explain about operator precedence in vb script?
what do you mean .ota mobile format
What's the difference between vbscript and vb.net?
I want good books or good sites for scripting.Can any one help me.
How will you get a combined string from array of string in vbscript?
write a vb script to display ***** ***** ***** ***** *****
ASP 
