-
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
Learn How to Create Record Using Flow in Salesforce
Go to Setup, enter flow in Quick Find then select Flows. Click on New Flow. From the template, select Screen Flow. Go to Object Manager…
Salesforce for Logistics Industry | All You Need to Know
The logistics industry has evolved from just stock-keeping to maintaining a large amount of inventory management and handling of that inventory with Unique IDs related…
User Agent Flow in Salesforce | The Developer Guide
User Agent Flow (Mobile App Integration) A simple flow for clients that don't need to include global secrets (such as distributed apps) but can be…
Popular Salesforce Videos
Salesforce Consultant Career | Salesforce Career Path | Salesforce Consultant Certification
If you're interested in becoming a Salesforce consultant, one of the first things to consider is how much education you need. We've determined that 60.2%…
What is Validation Rule in Salesforce? Explain in details
Validation Rule will check the data entered by user during insert or update the operation and as per that it will actually take the action.…
Event Driven Development on Salesforce | All About Event in Salesforce
In this session, we will talk about Event-Driven Development in Salesforce. Let’s take a look into the many ways events have changed the way we…
