Email & Website Address Validation

[TotalSolutions]

How to validate e-mail address so that only letters (a-z), numbers (0-9), periods (.) and @ are allowed. Nothing else is allowed and the total lenght of the e-mail address should not exceed 50 characters.

Same for Website address but without the @ ofcourse!!

Thank You!!

[Suvrutt_Gurjar]

For email, in Email column’s valid_if, please try

AND(ANY(EXTRACTEMAILS([_THIS]))=[_THIS], LEN([_THIS])<51)

The column is assumed to be Email type.

[TotalSolutions]

That is Fab!! one more thing I want to do is that I also want to make sure the e-mail address is entered in lower case.

Also please let me know how to validate the website url.

Thanks!!

[Suvrutt_Gurjar]

Total_Solutions:

I want to do is that I also want to make sure the e-mail address is entered in lower case.

Please try

AND(ANY(EXTRACTEMAILS([_THIS]))=[_THIS], LEN([_THIS])<51, FIND(LOWER([_THIS]),[_THIS])=1)

Total_Solutions:

Also please let me know how to validate the website url.

Please try this based on the above expression or an expression based on similar expression.