Jump to content

Validation of Field AB123456


This topic is 2295 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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 by comment
Link to comment
Share on other sites

This topic is 2295 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.