-
Restricting characters and removing space at the end of a field?
I want to restrict the following characters ‘ “ , * % @ and if possible remove any extra spaces at the end of the field. , I don't really want to have to input every single charachter other than those listed above. Any guidence would greatly be appreciated.
-
1 Reply
-
Hi Tanu,
You can use this formula example to validate against usage of those special characters and checking if there are spaces at the end.
OR(
CONTAINS( Text_Field__c , "'"),
CONTAINS( Text_Field__c , '"'),
CONTAINS( Text_Field__c , ","),
CONTAINS( Text_Field__c , "*"),
CONTAINS( Text_Field__c , "%"),
CONTAINS( Text_Field__c , "@"),
CONTAINS(RIGHT(Text_Field__c, 1), " ")
)I hope this helps.
Log In to reply.
Popular Salesforce Blogs
Salesforce Sales Cloud Features for Smart Management
If you want to centralize your sales data, automate workflows, connect your team members, and use your data to power more deals, then yes. Sales…
Loan Processing, Qualification, and KYC Automation in Salesforce
Financial institutions always work on improving customer service, so they strive for improvements in work efficiency. The most important feature they need here is process…
External Objects in Salesforce - The Implementation Guide
External Object is a kind of virtual object which does not exist in your Org. It is a custom object like other custom objects we…
Popular Salesforce Videos
Introduction to Salesforce OmniStudio | Salesforce Industries
Introduction to Salesforce OmniStudio: The Salesforce OmniStudio digital engagement suite makes it easy to click-configure rich, consumer-grade user experiences based on objects, APEX classes, REST…
Salesforce Interview | Marketing Cloud Success
What's it like to learn Marketing Cloud from scratch? Akasia Perran has the answers and in this video, I ask her about her experience starting…
Avoid Common Security Mistakes in Salesforce
Are you using Salesforce in the most secure way? Security is not a “set it and forget it” thing. We conduct Salesforce Security Risk Assessments…