You need to sign in to do that
Don't have an account?
Abc234
validations on text
i have filed named PAN CARD with length 10, so i need to validate that filed with below requirment
1st 5 characters should be alphabets, next 4 characters are numbes and 10 place should be alphabet
for example :
AIEPV4202F
Use this as a validation rule on your object, replacing FieldName__c with the name of the field, as appropriate.
NOT(REGEX( PAN_Number__c__c ,"^\\w{5}\\d{4}\\w$"))
When I use this am getting below error
Error: Incorrect argument type for function 'REGEX()'.
Instead of I used NOT( REGEX( PAN_Number__c , "[A-Za-z]{5}[0-9]{4}[A-z]{1}") )--it's working for me
the basic issue i observed is you entered the api name incorrectly in the REGEX provide by SFDC Fox, but gave it correctly in the second REGEX, api name will never consists a __c twice.
--yvk
i have entered API name correctly both REGEX But while replying to your comments i have written api name __c twice in 1st REGEX its my typo
Regards,
Bharath