Restricting characters and removing space at the end of a field

Question

I want to restrict the following characters ‘ “ , * % @ and if possible remove any extra spaces at the end of the field. I've found validation rules for allowing characters but none for just restricting, I don't really want to have to input every single charachter other than those listed above. (infact when I try to do that I get syntax errors). Any guidence would greatly be appreciated.

Terence Chiu · Accepted Answer

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), " ") 
)

Miroslav Smukov · Answer

You can use regular expression in your validation rule to do this as well:   !REGEX( YourField , "^[^\"',*%@]+$") This is the part that contains your characters: \"',*%@ Note that " had to be escaped with backslash \  For removing the extra spaces I would write a trigger or workflow - something like this maybe:  https://success.salesforce.com/answers?id=90630000000Co59AAC

Restricting characters and removing space at the end of a field

Formulas

Risorse di formazione correlate

Ulteriore assistenza