In my SharePoint list, I need a text column [ID] to validate as 5 numbers, a period, and then 3 numbers. Example: "15202.123" and I need help. :-)

Thank you!

1 Answer 1


Try this:


First it validates if it's a 9 character string or not, then checks if the 6th character is a dot (.), then it validates the first 5 and last 3 characters.

Of course, it might be possible to write in an easier way.

Let me know if this helps.

  • UBK! Thank you!!! This is exactly what I was looking for. I REALLY appreciate your time and brilliance. Cheers!
    – ChasEpes
    Commented Jan 22, 2021 at 12:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.