Processing __js when using eval () to turn JSON into an object with a space error

When you convert a JSON string to a JSON object with eval (), the conversion fails if there is a space in the value value.

Workaround:

1. Use JS Replace method to remove space

var str = "SSSs DDADF";
var re = str.replace (/\s+/g, "");//delete all spaces;


2. Use the Replace method in SQL Server to remove spaces

Replace (replace (replace (with space string, ', '), char (9), '), char (+), '), char (13), ')
Such as:
Update table name set field name =replace (replace (replace (field name, ', '), char (9), '), char (+), '), char (13), ')