Here I faced one situation where I’ve to just extract alphabets and it was occurring in a flat file several times, and I have to read the string and remove all numeric and special characters from it.
First I did some approach using split and instr but then I read and searched more and stumbled upon below approach to use Vbscript Regular Expression object.
Set objRegEx = CreateObject("VBScript.RegExp")
objRegEx.Global = True
objRegEx.Pattern = "[^A-Za-z]"
xSearchString = "[email protected]#$%&*(_+"
xSearchString= objRegEx.Replace(xSearchString, "")
MsgBox xSearchString ' output !!!