Invalid if email address contains certain characters ie commers spaces etc

How do i use the expression invalid if email address contains certain characters ie ; , " " etc, for the comer I have tried “CONTAINS([EMAIL], “,”)” in the Invalid value error column but it does not work

Try with this:


Unfortunately not, the column is Title “Clients Email” if that makes a difference
This statement is false:
…(".,:;-,_") contains the text value (USEREMAIL())


NOT(CONTAINS(".,:;-_", [Clients Email]))

I hate to seem argumentative and please correct me if I am wrong!

I believe the arguments in the CONTAINS() function need to be reversed like so,

...CONTAINS([Clients Email], "..."))

Also I don’t think the function treats ".,:;-_" as a list of items. Instead it will search for that as a substring in the email so will likely always return FALSE.

Unfortunately I don’t think CONTAINS() excepts a list at all. So you would need a separate CONTAINS() function for each special character you wanted to check against.

       CONTAINS([Clients Email], ","),
       CONTAINS([Clients Email], ":"),

FYI, I tried testing with IN() function. It is no better than the CONTAINS() function.

1 Like


    CONTAINS([EMAIL], ","),
    CONTAINS([EMAIL], ";"),
    CONTAINS([EMAIL], " "),

It’s bulky, but it’s the only way to do it.