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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain a few date functions in vbscript

547


how to write validation function for date in vb script

2130


Illustrate briefly about the different types of statement

2014


How to create a cookie using vbscript?

576


Which date function is used in the vbscript language to find the difference between the 2 dates?

583






Explain about the extension .hta?

612


Dear All, I am geting below IE error whilie executing the QTP scripts in Batch mode "Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." can any one suggest me how to resolve this issue . Thanks Balaji

1230


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.

2543


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.

1508


What is difference between vbscript and vba?

598


Is vbscript language a case-sensitive language and what does it mean?

536


How to throw an error in vbscript?

593


Which operator can be used to check if two numbers are equal or not in vbscript?

639


Is vbscript a case-sensitive or case-insensitive?

744


what is the use of QCUtil? explain with one example?

6311