SharePoint Using column validation to validate an E-Mail Adress

The Column validation of SharePoint is really great in 2010 as well as 2013. So i was looking for a possiblity to validate a textbox wether the user entered a valid email adress or not. After trying and figuring out what might be a good solution i came to the really great post of Chris Kent. He did a really great job – thank you Chris!

He posted the validation code below, which i tested and it works like a charm.



=AND(
ISERROR(FIND(" ", [Mail],1)),
IF(ISERROR(FIND("@", [Mail],2)),
FALSE,
AND(
ISERROR(FIND("@",[Mail], FIND("@", [Mail],2)+1)),
IF(ISERROR(FIND(".", [Mail], FIND("@", [Mail],2)+2)),
FALSE,
FIND(".", [Mail], FIND("@", [Mail],2)+2) < LEN([Mail])
)
)
)
)


You should look at his post, he explains also what exactly happens.

..:: I LIKE SHAREPOINT ::..

The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.

Karsten Pohnke About Karsten Pohnke
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.

Submit comment

Allowed HTML tags: <a href="http://google.com">google</a> <strong>bold</strong> <em>emphasized</em> <code>code</code> <blockquote>
quote
</blockquote>

Please fill in the captcha: * Time limit is exhausted. Please reload CAPTCHA.