Query For Validation of Mobile Number with Country Code

Question

Hello Friends...!!!

I am using SharePoint 2013.I just entered Mobile Number in Lists Library.But the mobile number entered is not in Validated Form.

I need to add mobile number with country code i.e.+(91)

Please help me out Guys to make validation for Mobile Number with Country Code. i.e+(91)xxx-xxxx-xxx

Example-+(91)987-6543-210.

Thanks In Advance...!!!

Answer 1

Hi Sangram,

For validating Mobile number you have to create phone column as single line of text and need to insert validation formula with appropriate error message. please follow below steps to achieve your requirement.

 

For formula please refer this URL: https://www.premierpointsolutions.com/training/help-and-how-to-articles/how-to-validate-strict-text-formats-in-sharepoint-2010/

result will be: 

--------------------------------------------------------------------------------------------------------------

Thanks/ Siddheshwar Kohale

Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful. It'll help other users who are visiting your thread for the similar problem.

https://skdeveloper.wordpress.com/

Answer 2

Hi,

Please use the following Formula:

=IF(Len(Phone) = 17,
 AND(
 MID([Phone],1,1)="+",
 MID([Phone],2,1)="(",
 MID([Phone],3,1)="9",
 MID([Phone],4,1)="1",
 MID([Phone],5,1)=")",
 CODE(MID([Phone],6,1))>47,CODE(MID([Phone],6,1))<58,
 CODE(MID([Phone],7,1))>47,CODE(MID([Phone],7,1))<58, 
 CODE(MID([Phone],8,1))>47,CODE(MID([Phone],8,1))<58, 
 MID([Phone],9,1)="-",
 CODE(MID([Phone],10,1))>47,CODE(MID([Phone],10,1))<58,
 CODE(MID([Phone],11,1))>47,CODE(MID([Phone],11,1))<58,
 CODE(MID([Phone],12,1))>47,CODE(MID([Phone],12,1))<58,
 CODE(MID([Phone],13,1))>47,CODE(MID([Phone],13,1))<58,
 MID([Phone],14,1)="-",
 CODE(MID([Phone],15,1))>47,CODE(MID([Phone],15,1))<58,
 CODE(MID([Phone],16,1))>47,CODE(MID([Phone],16,1))<58,
 CODE(MID([Phone],17,1))>47,CODE(MID([Phone],17,1))<58
 ), False)

Best Regards,

Dennis

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].