Apex Code Development You need to sign in to do that
Don't have an account?
Syam Reddy 11 Validation rule for PAN Number
I have a requirement for PAN Number field should include 5 text, 4 Number and 1 Text characters should include for that i wrote validation rule.
Rule passed succesfully, but record is not saving in any formates. Can you please let me know the my mistake.
NOT(AND(
(REGEX( PAN_Number__c , "[A-Z][a-z]{5}[0-9]{4}[A-Z][a-z]{1}") ),
LEN( PAN_Number__c) <> 10))
Thanks in Advance!
SyamReddy.
Rule passed succesfully, but record is not saving in any formates. Can you please let me know the my mistake.
NOT(AND(
(REGEX( PAN_Number__c , "[A-Z][a-z]{5}[0-9]{4}[A-Z][a-z]{1}") ),
LEN( PAN_Number__c) <> 10))
Thanks in Advance!
SyamReddy.
The correct way to check whether charachter is either in small or capital is : [A-Za-z]
Try this :
NOT( AND( REGEX(Pan_Card__c,"[A-Za-z]{5}[0-9]{4}[A-Za-z]{1}") , LEN(Pan_Card__c) =10 ) )OR you can remove the length check by giving the field length as 10. In this way the first check will do.
All Answers
The correct way to check whether charachter is either in small or capital is : [A-Za-z]
Try this :
NOT( AND( REGEX(Pan_Card__c,"[A-Za-z]{5}[0-9]{4}[A-Za-z]{1}") , LEN(Pan_Card__c) =10 ) )OR you can remove the length check by giving the field length as 10. In this way the first check will do.