function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
KotiSFDCKotiSFDC 

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
Hi,

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

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

Thanks
Ajay
sfdcMonkey.comsfdcMonkey.com
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 
thanks 
KotiSFDCKotiSFDC
Tank you
sfdcMonkey.comsfdcMonkey.com
Welcome :), if you got your solution then close your query by choosing best answer so this question will remove from unanswerd queue 
thanks
Malika Pathak 9Malika Pathak 9

Hi,

Please try the Validation rule something like this 
NOT(REGEX( your field name ,"^[a-z  A-Z]*$")))

if you find this helpful mark it as the best answer.