I am trying to evaluate specific character entries in a string. Is there a function to evaluate a character as alpha, numeric and other?
For instance I have the following lines of code where:
varWord = "Dr-10"
ElseIf InStr(varWord, rstSList(2)) Then
lngPos = Len(rstSList(2))
What I need to do is evaluate the characters to the right of the "Dr" entry. Part of the result needs to parse the varWord entry, but the rest needs to remove the non-alpha and non-numeric characters. As a further example:
varWord = "Dr.-10"
How can I get the result?:
Result = "Dr 10"
I've done many string parsing routines B4, but not like this one. Any help/suggestions would be appreciated.