Any ideas on how I can prevent users from using special characters in list item names? These characters cause a workflow error when creating a new item in another list. (When I remove the special characters the workflow succeeds).
Thanks -bill
Actually found the formula through search (many, many hits on the same formula…. thanks to all of the 100’s of people who posted it) Copied from Matt Lally’s Blog
I am glad I could help you! I would never be able/have the patience to write that formula. Nice Job!
Thanks Vlad….. I have never used column validation before and forgot it was there!
Entered the following formula and works great.
=AND(IF(ISERROR(FIND(“,”,Title)),TRUE),IF(ISERROR(FIND(“&”,Title)),TRUE),IF(ISERROR(FIND(“!”,Title)),TRUE),IF(ISERROR(FIND(“@”,Title)),TRUE),IF(ISERROR(FIND(“~”,Title)),TRUE),IF(ISERROR(FIND(“#”,Title)),TRUE),IF(ISERROR(FIND(“$”,Title)),TRUE),IF(ISERROR(FIND(“%”,Title)),TRUE),IF(ISERROR(FIND(“^”,Title)),TRUE),IF(ISERROR(FIND(“*”,Title)),TRUE),IF(ISERROR(FIND(“(“,Title)),TRUE),IF(ISERROR(FIND(“)”,Title)),TRUE),IF(ISERROR(FIND(“-“,Title)),TRUE),IF(ISERROR(FIND(“=”,Title)),TRUE),IF(ISERROR(FIND(“+”,Title)),TRUE),IF(ISERROR(FIND(“:”,Title)),TRUE),IF(ISERROR(FIND(“;”,Title)),TRUE),IF(ISERROR(FIND(“<“,Title)),TRUE),IF(ISERROR(FIND(“>”,Title)),TRUE),IF(ISERROR(FIND(“?”,Title)),TRUE),IF(ISERROR(FIND(“‘”,Title)),TRUE),IF(ISERROR(FIND(“{“,Title)),TRUE),IF(ISERROR(FIND(“}”,Title)),TRUE),IF(ISERROR(FIND(“[“,Title)),TRUE),IF(ISERROR(FIND(“]”,Title)),TRUE),IF(ISERROR(FIND(“.”,Title)),TRUE),IF(ISERROR(FIND(“/”,Title)),TRUE),IF(ISERROR(FIND(“\”,Title)),TRUE),IF(ISERROR(FIND(“”””,Title)),TRUE))
Don’t got a VM open to confirm, however can’t you “Validate” a column using a regular expression? You would then be able to allow a-z A-Z 0-9!
I am getting a syntax error saying and is not supporting. Any other insight