How to return only alpha bate string from an string str = "bibhu@#$%&d

How to return only alpha bate string from an string str =
"bibhu@#$%&das&*)(SUndar"

Question Posted / bibhu d

4 Answers
5848 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to return only alpha bate string from an string str = "bibhu@#$%&das&*)(SUndar&quo..

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

How to return only alpha bate string from an string str = "bibhu@#$%&das&*)(SUndar&quo..

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

How to return only alpha bate string from an string str = "bibhu@#$%&das&*)(SUndar&quo..

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

How to return only alpha bate string from an string str = "bibhu@#$%&das&*)(SUndar&quo..

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

Post New Answer