09
12/16
C#去掉回车等ASCCII码特殊字符
C#去掉回车等ASCCII码特殊字符 cellValue = cell.ToString().Trim().Replace(((char)10).ToString(), "").Replace(((char)13).ToString(), "").Replace(((char)32).ToString(), "");
09
12/16
sql去掉回车等ASCCII字符
-- UPDATE [dsms].[dbo].[Equipments] SET code=REPLACE(code,CHAR(10),'') UPDATE [dsms].[dbo].[Equipments] SET code=REPLACE(code,CHAR(13),'') UPDATE [dsms].[dbo].[Equipments] SET code=REPLACE(code,CHAR(32),'') sql去掉回车等ASCCII字符