Validation of Special Characters in Sharepoint Field Columns

Of course, Infopath form is a known method to validate the SharePoint list columns. The Infopath form comes with an inbuilt validation for each of the fields.

Let's say, you have to validate a SharePoint list column for the special fields without using the Infopath, the only option we have is the Validation Settings under the List setting tab.

Steps

  1. Go to the Custom List where you will be validating for the special characters
  2. Click on the ribbon "Library Settings "
  3. Select "Validation Settings"
  4. Click on the Column validation
  5. Paste the following rule

    IF(ISERROR(FIND(",",Title)),TRUE),IF(ISERROR(FIND("&",Title)),TRUE),IF(ISERROR(FIND("!",Title)),TRUE),
    IF(ISERROR(FIND("@",Title)))

    This rule checks for the special characters such as ',', '&', '!', '@'
     
  6. In the User Message section, please mention "Special characters are not allowed"
Ebook Download
View all
Learn
View all