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.
[sourcecode language=”csharp”]
=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])
)
)
)
)
[/sourcecode]
You should look at his post, he explains also what exactly happens.
..:: I LIKE SHAREPOINT ::..
Leave a Reply
You must be logged in to post a comment.