How to Check Alphanumeric's from webtable

[branjitk]

Hi all,

Good Morning to all.

I am having one doubt, For checking a condition from web table cell contains alphanumeric data. In that cell some part is constant and remaining part is changing. How to check this type of condition.

Cell values: To : Islamabad (ISB)
To : Karachi (KHI)
To : Peshawar (PEW)

Here, i done below ways to check the condition,but it is not working.

Code:

If var = "To : " & "[A-Za-z()]" Then
End If.
and
If var = "To : " + "[A-Za-z()]" Then
End If.

Regards,
Ranjit B

[supputuri]

Please check the below code

Code:

myvalue = "Karachi (KHI1-)"

Set regexp = New RegExp
regexp.Pattern =  "[^\w\(\)\s]"
regexp.Global = True
regexp.IgnoreCase = True
set Matches = regexp.Execute(myvalue)
msgbox Matches.Count
If Matches.Count = 0 Then
    msgbox "input contains only alphanumerics and spl chars ()"
else
    For Each Match in Matches
        msgbox Match
    Next
End If