How to separate a string

[sreekanth chilam]

Hi Linhke,

Check with the below example, it would give only the charcter string by ignoring Numericals.

Code:

Dim Str,temp,i,x
   Str="Ref1234"
   temp=""
   For i=1 to len(Str)
         x=mid(Str,i,1)
         If isnumeric(x)<>true Then
    temp=temp&x
         End If
   Next
   Str=temp
   msgbox Str