SharePoint developers are facing many challenges in the data validations. One of these challenges is validating the email address. Emails are stored in SharePoint column with data type single line text and this will allow the users to enter any character series with maximum number 255 which will require data validation.
- Validate if the e-mail column includes . & @
=AND(IF(FIND(“@”,Email,2)>0,if(FIND(“.”,Email,2)>0,true,false),false)
2. Validate if the e-mail column includes . & @ and @ comes after . at least by 2 characters
=AND(IF(FIND(“@”,Email,2)>0,if(FIND(“.”,Email,FIND(“@”,Email,2)+2)>0,true,false),false)
3. Validate if the e-mail column includes . & @ and @ comes after . at least by 2 characters. Also, there is at least 2 characters after @
=AND(IF(FIND(“@”,Email,2)>0,if(FIND(“.”,Email,FIND(“@”,Email,2)+2)>0,if(FIND(“.”,Email,FIND(“@”,Email,2)+2)<len(Email),true,false),false),false)
Enjoy a valid email data entry.
Best view i have seen for long time !
Thanks again for the blog article. Thanks Again. Much obliged. Oralla Rikki Dwane
Its not my first time to pay a visit this site, i am browsing this website dailly and get nice information from here everyday. Elnore Javier Itagaki
I just wished to take a minute to let you understand that I enjoy I located this article on your blog. You have actually exceeded and also beyond in your research. I want to find out more posts about this subject on your blog site in the future. Thank you so much for guaranteeing I do not have to search the net for this subject any much longer. Monique Dalis Tammie
I simply wanted to compose a small message to be able to say thanks to you for these amazing tips and hints you are sharing at this website. My long internet look up has at the end been compensated with beneficial content to talk about with my family. I would admit that we visitors actually are definitely endowed to live in a remarkable place with very many brilliant people with useful tactics. I feel quite grateful to have seen your site and look forward to so many more excellent moments reading here. Thank you again for a lot of things. Jerrine Hazlett Emmeram
Way cool! Some very valid points! I appreciate you writing this write-up and also the rest of the website is very good. Kitty Welsh Laurianne
i love that this is something i can have done in 30 minutes! Cyb Randolph Delmer
I just could not leave your website before suggesting that I extremely loved the standard info a person supply on your guests? Is going to be back regularly in order to check out new posts. Samantha Brantley Xena
Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how could we communicate?| Fanya Hersch Burk
Very good article. I certainly love this site. Continue the good work! Emmie Luciano Lareena
Very good article. I definitely love this website. Keep it up! Margery Morey Ermengarde
I really like the design and contents of your web page Lurette Marshall Lila
Youre so cool! I dont suppose Ive learn something like this before. So good to seek out any person with some unique thoughts on this subject. realy thanks for starting this up. this website is one thing that is needed on the web, someone with slightly originality. useful job for bringing one thing new to the internet!
I used to be recommended this website through my cousin. I am now not sure whether or not this submit is written via him as nobody else recognize such distinct approximately my problem. You’re amazing! Thanks!