-
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.
