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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i am having some basic knowledge in c and VB 6.0. i qtp i want to know how to write the codings. by recording it is generating lot of codings. for example i want to test the text box. senerio is text box should not accept alphabets if it accept alphabets we should return fail status if it get number we should return pass status. how to write coding in vb script please help me

1786


1.I want to establish connection with excel and also want to fetch the data using SQL queries. 2.the code should be written in such a way that in future if I want to migrate from excel to MS excess database , then there should be minimal changes.

1506


filter the array values without using filter function?

1641


How you can call vbscript functions?

567


How to access array data?

531






What purpose does ‘on error resume next’ serves?

536


Why is it recommended to close the database connection every time after the work is completed?

488


What is the main difference between function and sub-procedure?

542


Can anyone send me a vb script function for verifying the functionality of active links on a web page

1586


write a program to display configuration of a local system with the help of vb script.

1676


wht must be the interview question on corinthian information technology solutions incorporated.

2173


Which object is used to work with the database in the vbscript language and what statement is used to create this object?

500


What are the properties of regexp object?

569


Is VB Script Case sensitive or Case insensitive?

622


Hi Friends, I have an issue like the describe below: I'm using QTP and I'm testing on SharePoint. As you knoe, SharePoint has a customize function for user, so that, If I add an object Web Table at the first time, that object was recognized by "index" and "html tag", after that, if someone change the display of web part, the "Index" of my object was changed as well and QTP unable to select that Web Table. Can you guide me how to identify or anyway to keep that Web Table object as unique object? Thanks a lot.

2541