function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
WonderfulStarWonderfulStar 

Help with Validation Rule needed...

Hi if anyone can help with creation of a validation rule that ensures the first 3 digits are "INV" and the last 5 digits are numerical only it would be great.  Below is what I created so far however it doesn't ensure the last 5 are numerical.

 

NOT(
OR(
ISBLANK( X4D_Invoice__c),
LEN( X4D_Invoice__c) = 8,
LEFT(X4D_Invoice__c,3 ) = "INV"))

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

I haven't got time to bang out a VR Formula right now, but what you want is a REGEX Function.   

 

https://help.salesforce.com/apex/HTViewHelpDoc?id=customize_functions.htm&language=en  

 

https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_useful_field_validation_formulas.htm&language=en  

 

All Answers

Steve :-/Steve :-/

I haven't got time to bang out a VR Formula right now, but what you want is a REGEX Function.   

 

https://help.salesforce.com/apex/HTViewHelpDoc?id=customize_functions.htm&language=en  

 

https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_useful_field_validation_formulas.htm&language=en  

 

This was selected as the best answer
WonderfulStarWonderfulStar

Thanks so much this worked great!  Unfortunately I could not access the help files so I just tested in my DEV environment.