I am using a DataQualityRule. I am trying to give a warning of an email address does not conform to a regex that I have. I have tested the regex at the page here: http://bit.ly/2aQ8bh as well as in a console app and it is valid and working.
I am not caring if the field is empty or just a space. The problem is if there is any value in the email address field, it returns the warning. Here is my rule, can anyone let me know what I'm doing wrong? Thanks!
IsNullOrEmpty(EmailAddress) or IsNullOrWhitespace(EmailAddress) or IsMatchRegEx("^([a-zA-Z0-9_\\-\\.]+)@((\\[[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.)|(([a-zA-Z0-9\\-]+\\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\\]?)$", EmailAddress)
