-
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
Interview Question Part – 3
1. What is an Apex class in Salesforce? An Apex class in Salesforce is a blueprint or template for creating custom business logic and functionality.…
An Introduction to Salesforce Service Cloud
In this era, customers expect service to be as instant and also as easy as their normal conversation. Service Cloud is an easy to use…
Learn All About Visualforce in Salesforce - The Complete Guide
Introduction With the help of the web development framework Visualforce, programmers may create complex, unique user interfaces for desktop and mobile apps that can be…
Popular Salesforce Videos
Code Review in Salesforce
Code Review and Code Quality in Salesforce 0:00 Introduction 0:44 What is code review? 1:22 Why we need code review 3:33 Basic code review 4:12…
How to Get Experience Without the Job? | Salesforce Learning
Want to get experience without the job? Watch the full episode here: https://youtu.be/oG8sHOW8GI4 Shrey is a Chief Executive Officer at Cyntexa, a SILVER Salesforce Consulting…
Salesforce Quickbooks Integration | eShopSync for Quickbooks
Product Sync? Invoice Sync? And more? eShopSync for Quickbooks brings out the best-class solution for Salesforce Quickbooks Integration. Click on the link to know more:…
