07-20-2015 07:09 AM
My understanding is that this function returns a position of the first letter of the alphabet in a string. Is there a similar function that include all non-numeric symbols.
The code I'm using is if anyalpha(field1) eq 0 then field2 = field1;
else field2 = 0;
But I'm not sure what function I should use if there is "/", "-", etc.
07-20-2015 08:13 AM
Have you tried:
Note I just added _ to give it something to work with, the main part is the 'a' which adds all the alpha characters.
Need further help from the community? Please ask a new question.