Sharepoint Column Validation - Regex

Question

i would like to do data validation on a column in SharePoint to ensure the naming convention of my documents are correct.

Im familiar with RegEx and was able to build the below Expression :
[A-Z]{4}-[A-Z]{3,6}-[A-Z0-9]{2}-[A-Z0-9]{2}-[A-Z]{2,3}-[A-Z]{1,3}-[0-9]{4}-[A-Za-z0-9]+

is there anyone that can assist converting this to a format that Sharepoint understands?

Answer 1

Hi @Ruan Swart ,

Welcome to Q&A Forum!

According to my research and testing, SharePoint Column Validation cannot support such a complex RegEx Expression. Because the Validation Formula must be 1024 characters or fewer.

For example:

[A-Z]{4}- requires the following Formula:

=IF(AND(LEN(Test)=5,CODE(MID(Test,1,1))>64,CODE(MID(Test,1,1))<91,CODE(MID(Test,2,1))>64,CODE(MID(Test,2,1))<91,CODE(MID(Test,3,1))>64,CODE(MID(Test,3,1))<91,CODE(MID(Test,4,1))>64,CODE(MID(Test,4,1))<91,MID(Test,5,1)="-"),TRUE,FALSE)  

Thanks,
Echo Du

=========================================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thank you for the great feedback :)