-
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 Quickstart: How to Implement Salesforce Quickly and Maximize your Productivity
Salesforce is a leading Customer Relationship Management (CRM) software used globally by businesses of all sizes in terms of market share. However, Salesforce implementation can be overwhelming,…
Custom Roll-up Summary on Account Object | Salesforce Developer Guide
In this blog, I would like you to share, how to display a custom roll-up summary on account, Before moving to code first create a…
Why ISVs Must Strive Harder To Be On AppExchange?
Are you on Salesforce AppExchange? How many apps do you have on Salesforce AppExchange? If you are an ISV then you must be pretty aware…
Popular Salesforce Videos
Control Access to the Org | Data Security | Salesforce
In this video, wonder Studies explains how to control access to your Salesforce org and the data security measures you can take to protect your…
AMPscript Case Functions - Salesforce Marketing Cloud Functions in 5 minutes
Cameron Robert steps through how to use the Upper, Lower and Proper Case Functions in AMPscript. Cameron also takes a closer look at the ProperCase…
What is Audit Trail in Salesforce?
The Setup Audit Trail feature in Salesforce enables you to closely track changes made to your organization. It records all modifications concerning the administration, customization, security,…
