JSON formatting error if vbCrLf present in passed string data?

rowel

Using AJAX to pull data from an SQL server.
I get a JSON formatting error if there are any hidden vbCrLf (Carriage Return/Line Feed) codes in the passed string data.

For now, I resorted to filtering these invisible characters out and replacing them with spaces.

Is this due to the nature of the JSON format? no embedded carriage returns allowed inside the string?

rowel

vbTabs (invisible Tab) in string also causes a JSON error.

allan

Correct - that's part of JSON. It is jQuery which validates the JSON, not DataTables - I just call $.parseJSON .

Allan

rowel

Thanks Allan.