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.