Skip to main content
Topics#FormulasAmit Gomes の質問
Amit Gomes (Kiwi Routes Limited) が「#Formulas」で質問
2022年10月12日 21:44

Request Help Account Number format Validation using REGEX

REGEX(  AccountNumber  , "[a-zA-Z]{2}[0-9]{5}")

 trying to achieve below 

 

When creating or editing an Account, users are only  allowed to  enter Account Numbers that start with 2 letters followed by 5 digits.

 

This dosent seem to work and i am unable to find out the issue. Request help 

 

Thanks Amit 

2 件の回答
  1. Keiji Otsubo
    2022年10月12日 21:51

    Hi @Amit Gomes ,

     

    Try this

     

    AND(
    NOT(ISBLANK( AccountNumber )),
    NOT( REGEX(  AccountNumber  , "[a-zA-Z]{2}[0-9]{5}"))
    )
回答を記入...
0/9000