Skip to main content
Solved

Rules- with many conditions

O
Data Voyager

Hi, is it possible to have a  single rule that checks many condition. example is below  

 

i want a single rule named--Name Validation

i want this rule to check  and validate name that are in -

  • Title Case --first letter upper case follow by all lower case 
  • Accented--- Accepts accented character 
  • Accepts special characters 
  • Could have Hyphen - 

the rule should should invalidate any other names that does not meet these conditions . or is there a better way to do this ? preferred to break it down so its will be easy to know the reason why the names are not valid whenever its does not matches 

Best answer by srija piratla

Hi @olayinkadaramola ,

 

I see you want to have a single rule with all those conditions and please try this regex expression 

\b(?:[A-Z][a-z'à-öø-ÿ'-]*)(?:[\s-][A-Z][a-z'à-öø-ÿ'-]*)*(?:'[A-Z][a-z'à-öø-ÿ'-]*)?\b

This should satisfy all those conditions - 

  • Title Case --first letter upper case follow by all lower case 
  • Accented--- Accepts accented character 
  • Accepts special characters 
  • Could have Hyphen - 

I used all the examples here and it is working as expected . Please try this and let me know if you face any issues. Hope this helps.

 

Thanks,

Srija Piratla

View original
    Did this topic help you find an answer to your question?

    2 replies

    S
    Ataccamer
    Forum|alt.badge.img
    • srija piratlaAtaccamer
    • Ataccamer
    • 49 replies
    • Answer
    • June 20, 2024

    Hi @olayinkadaramola ,

     

    I see you want to have a single rule with all those conditions and please try this regex expression 

    \b(?:[A-Z][a-z'à-öø-ÿ'-]*)(?:[\s-][A-Z][a-z'à-öø-ÿ'-]*)*(?:'[A-Z][a-z'à-öø-ÿ'-]*)?\b

    This should satisfy all those conditions - 

    • Title Case --first letter upper case follow by all lower case 
    • Accented--- Accepts accented character 
    • Accepts special characters 
    • Could have Hyphen - 

    I used all the examples here and it is working as expected . Please try this and let me know if you face any issues. Hope this helps.

     

    Thanks,

    Srija Piratla

    Cansu
    1 person likes this
    • Cansu
      Cansu
    Cansu
    Community Manager
    Forum|alt.badge.img+3
    • CansuCommunity Manager
    • Community Manager
    • 625 replies
    • June 24, 2024

    Hi @olayinkadaramola, I’m closing this thread for now, if you have any follow-up questions please don’t hesitate to share them in the comments or create a new post 🙋‍♀️

    Check out our Quick Start Guide to get started on the community 🙋‍♀️

    Reply


    Most Liked this week

    Community Terms of Use & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings