topic Replacing invalid xml character (Unicode: 0xc) in Talend Studio

Replacing invalid xml character (Unicode: 0xc)

Anonymous — Thu, 20 Jun 2019 12:49:16 GMT

Hello All

I have a very large XML file. I am reading that file content and storing it in SQL table. Now my issue is the loading is stopping because of the error:

Exception in component tFileInputXML_1

org.dom4j.DocumentException: Error on line 1636464 of document : An invalid XML character (Unicode: 0xc) was found in the element content of the document. Nested exception: An invalid XML character (Unicode: 0xc) was found in the element content of the document.

since it is a very big file, I am not able to use tReplace. How can i solve this error?

Regards

Priya

Re: Replacing invalid xml character (Unicode: 0xc)

Anonymous — Thu, 20 Jun 2019 15:24:05 GMT

Hi @priyadarshiniv

Please read the xml using tFileInputFullRow -> tReplace -> tFileOutputDelimited (cleansed file).

Since it is a line by line operation, it will not require much memory to process.

Thanks and Regards,

Subhadip

Re: Replacing invalid xml character (Unicode: 0xc)

Anonymous — Mon, 24 Jun 2019 14:23:14 GMT

hi @subhadip13

Thank you for your reply. But the solution doesnt work. The way I have declared is:

I get error:

Detail Message: The method replaceAll(String, String, String) in the type StringUtils is not applicable for the arguments (Object, String, String)

Regards

Priya

Re: Replacing invalid xml character (Unicode: 0xc)

Anonymous — Mon, 24 Jun 2019 17:33:28 GMT

Hi Priya,

Could you please try to convert the Object to STring using a tCOnvertType. Add this component before tReplace and you can eliminate the above error.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂