且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

阻止用户在Sharepoint列表中输入不可打印的字符

更新时间:2023-11-09 08:57:58

嗨hamdana, 


你不能在文件/文件夹中使用以下字符名称:


Tilde(〜)

数字符号(#)

百分比(%)

&符号(&)

Asterisk(*)

大括号({})

反斜杠(\\)

冒号(:)

尖括号(<>)

问号(?)

斜线(/)

加号(+)

管道(|)

报价单(")

¥ b $ b如何验证SharePoint列表列上的特殊字符以供参考:



http://fairulshahrizat.blogspot.com/2012/12/how-to-validate-special-character-on.html


最诚挚的问候, 


Lisa Chen 



Hello,

Im looking for a column validation formula that prevents users from entering non-printable characters in a line of text in a sharepoint list.

I notice that users are entering a horizontal tab in the name, which then carries over into a file name that is created when they add an attachedment. However i get the following error when creating the name. It appear the "tab" they are entering in the name inserts a /t in its place. Is there a validation formula that remove these characters, I believe the ascii character is 9.

{
  "error": {
    "code": 502,
    "source": "flow-apim-msmanaged-na-northcentralus-01.azure-apim.net",
    "clientRequestId": "a5d8b2f7-80e1-4c15-87e1-7fcf637361c6",
    "message": "BadGateway",
    "innerError": {
      "status": 502,
      "message": "The file or folder name

Projects/225_Project Budget Form_Norms Project New\t_SD_2018-11-27_FD_2019-08-31.xlsx\

contains invalid characters. Please use a different name. Common invalid characters include the following: # % * : < > ? /  |\

Regards,

Ali

Hi hamdana, 

You cannot use the following characters in file/folder name:

Tilde (~)
Number sign (#)
Percent (%)
Ampersand (&)
Asterisk (*)
Braces ({ })
Backslash (\\)
Colon (:)
Angle brackets (< >)
Question mark (?)
Slash (/)
Plus sign (+)
Pipe (|)
Quotation mark (")

How to validate the special character on SharePoint List Column for your reference:

http://fairulshahrizat.blogspot.com/2012/12/how-to-validate-special-character-on.html

Best Regards, 

Lisa Chen