-
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
6 Challenges When Migrating To Salesforce Lightning And How To Overcome Them
If you are still a Salesforce Classic user, migration to Salesforce Lightning would be one of your priority. Aside from all the new features and…
Power Play: Mastering Salesforce Integration Patterns And Practices
Ready to turbocharge your Salesforce experience? In our hyper-connected global village, just owning Salesforce isn't enough. You need seamless integration with data, systems, and processes…
Salesforce Security Interview Questions
These questions cover a range of topics related to data security in Salesforce and should help you prepare for various aspects of Salesforce security management. …
Popular Salesforce Videos
Salesforce Announces New Salesforce CDP Updates | Salesforce CDP
Salesforce, one of the largest global providers of CRM solutions, launched Salesforce CDP last year. Salesforce Customer Data Platform is an enterprise customer data platform…
myTrailhead Product Filters | Salesforce Tutorial Video
Salesforce myTrailhead has now released their next update in product filters. You can now create your own product filters that are relevant to your business…
Customize Salesforce in a Flash with Lightning
This video shows you how to use Lightning App Builder to make page customizations without any code. This enables admins to tailor Lightning Experience for…
