-
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 Apex Practice Questions | All You Need to Know
Here are a few beginner-level questions related to Salesforce Apex for you to practice:
How to Create and Run Test Suite in Salesforce?
Test Suites : "A set of test classes that you want to execute together is called Test Suites. Test suites can be created for the…
What are Scheduled-Triggered Flows in Salesforce?
Schedule-Triggered Flow (or Scheduled Flow) is a Salesforce Flow that launches automatically and repeats itself at certain intervals. For a batch of records, a schedule-triggered…
Popular Salesforce Videos
Salesforce Work.com New Features
Work.com includes new solutions to accelerate the private and public sector's answer to the COVID-19 pandemic, ranging from contact tracing and emergency response management to…
Process Builder - A Tool every Salesforce Developer must know
Salesforce Process Builder - A Tool every Salesforce developer must know. Learn how to master Process builder Salesforce to automate your business processes. In this…
Salesforce — How To Market Your Small Business
How can small businesses get the word out about what they do, and be strategic about it? Here are three important steps to consider when…
