Formula:
1.Insert the following formula in the column validation section:
=AND(
ISERROR(FIND(" ", [Email],1)),
IF(ISERROR(FIND("@", [Email],2)),
FALSE,
AND(
ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),
IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),
FALSE,
FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])
)
)
)
)
Source: http://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/
2.Add a calculated column with the formula below:
=(LEN(LEFT([Email],FIND("@",[Email])-1))>0)
+(LEN(RIGHT([Email],LEN([Email])-FIND(".",[Email],FIND("@",[Email]))))>0)
+(LEN(MID([Email],FIND("@",[Email])+1,FIND(".",[Email],FIND("@",[Email]))-FIND("@",[Email])-1))>0)
+(ISERROR(FIND(" ",[Email]))=TRUE)
=4
Type: Number or Integer
Reference:
http://sharepointsolutions.com/sharepoint-help/blog/2011/12/how-to-validate-an-email-address-using-column-validation-in-sharepoint-2010/
No comments:
Post a Comment