-
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
Drive Financial Growth with Sage Intacct Consulting benefits
Businesses that use the right solutions will stay ahead of the curve in a constantly shifting commercial environment. This is where Sage Intacct, a financial…
Salesforce declares a new Content Management System
Salesforce announced a new tool named Salesforce Content Management System recently which is designed in an optimized manner to deliver a quality customer experience across multiple channels. The…
Benefits of Salesforce Implementation for Healthcare
Are you planning to implement Salesforce or still wondering if it will make sense to have expert Salesforce implementation services for healthcare? With an aim…
Popular Salesforce Videos
Salesforce Developer to Architect
In this video, we will look at the top considerations that are crucial to being a successful architect on the Salesforce platform. Even more, We…
Top 10 Reasons to Learn Salesforce | Why Should you Learn Salesforce in 2021
The "Top 10 Reasons to Learn Salesforce" video will give you good reasons to learn and start your career in Salesforce. We will address the…
5 Things Salesforce Lightning Does Better
In this 30-minute recorded webinar, Jamie Grettum talked about her favorite Lightning features, how to set them up, and how to get hands-on experience with…
