Validation of Field AB123456

[Tusif Ahmad]

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

[comment]

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

[Tusif Ahmad]

Thanks.. Very nice.. It worked 100% perfect. 

Edited March 17, 2016 by Tusif Ahmad