[RESOLVED] Unable to parse &# into JSON file - Character Reference "&# error

[cara_ay]

Hi, I'm trying to query a MySQL database to generate a JSON file. The dataset has &# but this was triggering the following error. After removing the &# from the dataset and re-running the job, I am still receiving the same error.

Have you got any suggestions on what I can do to resolve this?

Is it possible to parse &# values into the JSON file since I would prefer keeping these characters in the data?

Here is a screenshot of the job:

The error message that I've received.

 

UPDATE:

After trying to narrow this down to the column and row that contained the characters, it turns out that the characters weren't an ampersand (&) and hash (#), but rather the 'backspace' character (see attached image). After doing an update to remove this character, the job ran successfully.