Regular Expression for numbers alone validation in Salesforce
Sample Formula: NOT( REGEX( Miscallaneous__c , '[0-9]*' ) ) Cheers!!!
Sample Formula: NOT( REGEX( Miscallaneous__c , '[0-9]*' ) ) Cheers!!!
We have to use nested SUBSTITUTE() methods for multiple replacing of characters. Example: SUBSTITUTE( SUBSTITUTE( Name, " ", "" ) ,"-","" ) In this example, we can remove "-" and ....
Example: OR( AND( ISPICKVAL( Country_Code__c , "USA"),NOT( REGEX( Pincode__c , "\d{5}(-\d{4})?") ) ), AND( ISPICKVAL( Country_Code__c , "MEX"), NOT(REGEX( Pincode__c , "\d{5}")), NOT(REGEX( Pincode__c , "\d{6}")) ), AND( ISPICKVAL( Country_Code__c ....
Returns a value by looking up a related value on a custom object similar to the VLOOKUP() Excel function. The field_to_return must be an auto number, roll-up summary, lookup relationship, ....