cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Geeks_D
Super User
2 weeks ago

Data Validation PowerFx Code Using Regex Expression!

 

 

If(                                        //Conditional Statement
    CountIf(                              //If Statement
        Split(                           //Split each string into substrings
            AddressTxt.Value,            //TextInputControl
            ""                          //Splitting value
        ),
        Not(                            //Condition Expression
            IsMatch(                    //Match Function
                Value,                  //Condition Value
                "([A-Za-z0-9])"         //RegexExpression 
            )
        )
    ) > 0,                              //Condition
    "Wrong Character in-text"           //DisplayText
)