Tusif Ahmad Posted March 17, 2016 Share Posted March 17, 2016 Hi, I need a small help. I want to restrict ( Validate) one field as It should only accept two alpha followed by 6 numerics. Like EN123456 or DS654321 Can anyone let me know, how I will do this. Thanks in advance. Regards, Tusif Link to comment Share on other sites More sharing options...
comment Posted March 17, 2016 Share Posted March 17, 2016 (edited) You can validate by calculation. I think this one would cover the requirements, but I haven't tested it thoroughly: Length ( Yourfield ) = 8 and Length ( Filter ( Left ( Yourfield ; 2 ) ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ) = 2 and Length ( Filter ( Yourfield ; "0123456789" ) ) = 6 Edited March 17, 2016 by comment Link to comment Share on other sites More sharing options...
Tusif Ahmad Posted March 17, 2016 Author Share Posted March 17, 2016 (edited) Thanks.. Very nice.. It worked 100% perfect. Edited March 17, 2016 by Tusif Ahmad Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3054 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