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
- Go to the Custom List where you will be validating for the special characters
- Click on the ribbon "Library Settings "
- Select "Validation Settings"
- Click on the Column validation
- 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 ',', '&', '!', '@'
- In the User Message section, please mention "Special characters are not allowed"