+ Start a Discussion

validation rule for allowing only characters not even space

Hi i want to create a validation rule for the text field, that not allowing anything except 'a to z'
and i have written like this:
NOT(REGEX(Full_Name__c ,"[a-zA-Z]"))
but the field have not taken the characrs too. why?do you guys have any explination please .
and can anybody shrae me the right expresson for it .Note: to allow only characters (a to z)not even Space.
Ajay K DubediAjay K Dubedi

Try out using regex.
Below example to avoid numeric and special characters:

NOT(REGEX( FIELD NAME,"^[a-z  A-Z]*$")))

use below rule for avoid numeric, special char and spaces:
NOT ( REGEX ( Name__c,"[a-zA-Z]*" ))

i hope it helps you.
  Let me inform if it helps you and kindly mark it best answer if it helps you 
Tank you
Welcome :), if you got your solution then close your query by choosing best answer so this question will remove from unanswerd queue