Power Community

Power Community

Data Validation PowerFx Code Using Regex Expression!

image
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
)

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Capture and visualize ideas without spatial constraints using Infinite Canvas in Visio for the web

Following our announcement earlier this year about mind maps in Visio for the web, we’re excited to announce a...

More Articles Like This

- Advertisement -spot_img