Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ramesh SomalagariRamesh Somalagari 

Text field allows [a-z][A-Z] and space bar only

Hi

I have created one custom text(Text01__c) field.This field allows  characters [a-z][A-Z] and space bar only.Any formula or validation rule or workflow rule.It not allows numarics [0-9] and special character

Best Regards,
Ramesh
Best Answer chosen by Ramesh Somalagari
Prafull G.Prafull G.
Hi Ramesh,

Try the following validation rule
NOT(REGEX(Text01__c, "([a-zA-Z ])*"))

This will allow you to save records only when the field contains characters a-z or A-Z and space character.

Let me know if you find any dificultied in using this.

All Answers

Prafull G.Prafull G.
Hi Ramesh,

Try the following validation rule
NOT(REGEX(Text01__c, "([a-zA-Z ])*"))

This will allow you to save records only when the field contains characters a-z or A-Z and space character.

Let me know if you find any dificultied in using this.
This was selected as the best answer
Nikita Ghosh 19Nikita Ghosh 19
HI FOLKS,

'I HAVE SIMILAR FORMULA THAT ALLOWS TEXT, NUMERIC, * AND &
FORMULA: NOT(REGEX( Exist_partner_brand_custom_descrip_value__c,"^[a-z A-Z0-9 *& ]*$"))​

SO MY QUESTION IS HOW CAN I PUT SPACE BETWEEN THIS FORMULA?

THANKS 
​NIKITA