-
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 Admin vs. Consultant: Which One Should I Choose?
If chosen correctly, you can create a successful career in Salesforce. However, you have to understand the specific roles and responsibilities that every post has…
Continuous Integration and Deployment for Salesforce
Salesforce continues to be at the core of business operations for companies large and small around the world. It is an incredibly powerful tool, but…
Salesforce Marketing Cloud Summer'21 Top Features
With Marketing cloud, send your customer the right message at the right time on the right platform and increase your reach. Get a panoramic view…
Popular Salesforce Videos
Salesforce Admin Tutorial For Beginners
What is Salesforce Admin? Salesforce Admin is totally a Business Leader. Who should have in-depth knowledge, how the company operates. In designing all its Departments.…
Spring'21 Prior Value in Salesforce Record Triggered Flows - ISCHANGED IN Salesforce Flows
In this video, I'm talking about the Prior value feature in the Spring'21 pre-release that is for the record triggered flow. Pre-Release Org URL: https://www.salesforce.com/form/signup/prerelease-spring21/…
How To Create Workflow Rules In Salesforce | Salesforce Workflow Rules
This video walks through the steps to create a Workflow Rule within the Process Automation section of Lightning Settings in Salesforce. Get answers to the…
