+ Start a Discussion
venkateshyadav1243venkateshyadav1243 

Name should be capital and space will allowes

Hi

 

I need to show account name should be capital and it allow space

 

i written one validation rule its working but when i provide space its not working

this is my validation rule

not(regex(Name , "[A-Z]+-$"))

 

it is working for this if i give name TEST

it is working,but if i give name like this TEST VENKATESH its not wroking,

can any one tell me how  to give it will accept space

 

 

Regards

venkatesh.

 

PrabhaPrabha

use :

OR(not(regex(Name , "[A-Z]+-$")),CONTAINS(Name, " "))

 

it throws error if it has spaces or it doesnt have Caps...

 

HTH

Prabhan

venkateshyadav1243venkateshyadav1243

Hi Thanks

for you replay

 

i achive like this now its wroking for me

 

 

NOT(REGEX(Name,"^[A-Z]*$"))

 

 

 

Regards

venkatehs.

Pradip YadavPradip Yadav

Hi,

 

regex used to check the pattern of the expression.

not(regex(CaseValidation__c, "[A-Z]{1,50} [A-Z]{1,50}"))

1. You can pass the variable range in {}, so it will lenght of any character string between that range.

2. For the space between two string, use the space between two matching pattern.