-
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
Syncing Knowledge-Base Articles From Zendesk to Salesforce
Zendesk and Salesforce are two of the most widely-used platforms for storing knowledge bases. While there are multiple benefits of having a knowledge base, it…
Which SFDC API should you use?
API NameWhat It’s ForWhen to Use ItProtocolData FormatCommunication REST API Accessing objects in your organization using REST. You want to leverage the REST architecture to…
Salesforce Winter ‘20 Release Updates - Everything You Need To Know
It may still be summer, but winter is coming. It’s already time to start preparing for the Winter ‘20 release. With just over 3 weeks…
Popular Salesforce Videos
2020 Salesforce Admin Certification - Lightning Knowledge Base Setup
A Salesforce Admin Certification is the highest form of recognition a Salesforce Administrator can achieve; it demonstrates expertise in the field as well as a…
Introducing KaseSync: An Innovative Community-CRM Connector! | Salesforce
KaseSync, is an innovative community-CRM connector designed to create seamless bi-directional data sync between platforms. Learn how exactly it improved self-service and boosts community engagement.
What Is The Approximate Salary A Fresher Can Expect In The Indian Market Of Salesforce?
Wondering what is the approximate salary a fresher can expect in the Indian market of Salesforce? Join this useful group for Salesforce job & career…
