How to remove ‘non-numeric’ from a string?
Set objRegEx = CreateObject("VBScript.RegExp")
objRegEx.Global = True
objRegEx.Pattern = "[^A-Za-z]"
strSearch = “ABC$$$%%%^^+++”
strSearchString = objRegEx.Replace(strSearchString, "")
msgbox strSearchString
objRegEx.Global = True
objRegEx.Pattern = "[^A-Za-z]"
strSearch = “ABC$$$%%%^^+++”
strSearchString = objRegEx.Replace(strSearchString, "")
msgbox strSearchString
Comments
Post a Comment