SQL Replace tab, carriage return, line feed, and leading and trailing spaces

SQL Replace tab, carriage return, line feed, and leading and trailing spaces

When you recently bulk-repairing your data, you need to import large amounts of data using Excel. The data provided by the customer is not standardized, most of the data rows have tabs, carriage returns, and exchange characters, and I need to take the data first.
The usual method is to replace the corresponding symbol with replace, and you can define a function that merges them together.

The specific code is as follows:

--去除空格fn_trimcreate function fn_trim(@str nvarchar(max))returns nvarchar(max)BEGIN    --char(9) 水平制表符    --char(10)换行键    --char(13)回车键    return  LTRIM(RTRIM((replace(replace(replace(@str,char(9),‘‘),char(10),‘‘),char(13),‘‘))));end

SQL Replace tab, carriage return, line feed, and leading and trailing spaces