Is there a way to make a field based on another field but stop if you reach a number? See example below.
INTUNT5433 = INTUNT
INT876 = INT
EPINTUMB 343 = EPINTUMB
Thanks for the help
Is there a way to make a field based on another field but stop if you reach a number? See example below.
INTUNT5433 = INTUNT
INT876 = INT
EPINTUMB 343 = EPINTUMB
Thanks for the help
You only want the alphabetic characters?
The numeric characters are always at the end of the string?
A little more detail in the requirement description would be helpful.
make a custom function ,
usage: getNoNumTxt("INTUNT5433")
Code:Code:Public Function getNoNumTxt(ByVal pvVal) Dim vRet Dim i As Integer For i = 1 To Len(pvVal) If IsNumeric(Mid(pvVal, i, 1)) Then getNoNumTxt = Left(pvVal, i - 1) Exit Function End If Next End Function
Thank you. I will give that a try.
It worked. Thank you.