Validation rule - I Want First Character Upper Case In Multiple Words

Support
1

Please help me, I have no idea how to create such a validation rule.
Users insert full names in our database in different manners, and I don’t want to have any situations like this one>>

JOHN WAYNE
John Becks
Mary POPPINS Swart

I want all words to start with capital letter.

Thanks!

2

Hi,

Can you give us the ideal format based on the example you shared? For example, should the “JOHN WAYNE” be “John Wayne”?

1 Like
3

Hi, yes,

JOHN WAYNE should be John Wayne
AL MOHAMMAD ADNAN should be Al Mohammad Adnan

Thanks!

4

Any ideas? I couldn t figure it out until now! I d appreciate some help! :smiley: Thanks!

5

Hi,

You can try validation below:
^([A-Z]{1}[a-z]+\s?)*$