validation rule

Hello Trailblazers,

I need to create a validation rule for a text field. Data in the field must be in a specific format:

Five letters followed by "-" followed by five numbers followed by a decimal point followed by 2 numbers.

Examples of the correct format: PUNRI-00324.04

PITCU-00456.03

I would greatly appreciate it if anybody could help me with figuring out the formula for the validation rule?

Thank you

3 respuestas

Tony Trinh
16 mar 2021, 20:59
Actually try this:
NOT(REGEX(Text_Field__c, "[A-Z]{5}-[0-9]{5}[.]{1}[0-9]{2}"))

Agregar un comentario

0/9000

Data Management