JDBC to FILE- exception in XML Parser for Character "&#x1a"

Hello Guys,

I am working on JDBC to File scenario. JDBC adapter fetched some special character "" in the XML payload which results into SAXParseException as below:

Only one field has this special character. I am not using any mapping. Is there any way to deal with this special character by writing some UDF for that particular field? Or in the JDBC SQL (Select) query to remove/replace this special character?

Regards,

Simran