Newbies DaleScott Posted March 3, 2010 Newbies Posted March 3, 2010 I am looking for a function or calculation to determine if a text string contains any alpha characters or is all numeric. The implementation is for a check number field that will automatically increment by 1 for each new check. If the previous check is an electronic transfer there will be no check number in the field. The result is the next check number is 1. I want to keep the previous numerical check number stored if there is an alpha character in the field.
comment Posted March 3, 2010 Posted March 3, 2010 Try: not Exact ( text ; Filter ( text ; "0123456789" ) )
Newbies DaleScott Posted March 4, 2010 Author Newbies Posted March 4, 2010 Works like a charm. Thank you.
Recommended Posts
This topic is 5437 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now