You need to sign in to do that
Don't have an account?
RPReddy
Need help to validate vat number format
hi,
i need to validate vat number like this format "IE9X99999X".
here IE is the country prefix.
i have written validation rule NOT(REGEX( VAT_No__c , "(^(IE)\\[0-9]{1}\\[A-Z]{1}\\d{5}\\[A-Z]{1})?"))).
but it was not taking the input like that format.
any one can u help me.please.
Thanks&Regards,
Praveen
Try NOT(REGEX( Vat_No__c, "^IE[0-9]{1}[A-Z]{1}[0-9]{5}[A-Z]{1}$"))