invalid XML character (unicode: 0xB) while reading file

[Anonymous]

Hello!

I have a job which is initiated by wehook and which loads xml source file into sql table when user uploads the xml file. The job looks like 

now in one of the file I get this error while running this job.

how can i have them replaced? by using tReplace?

Regards

PV

[Anonymous]

Hi @priyadarshiniv 

You can store the Output file in your local directory and use the same in your job.

Thanks and Regards,

Subhadip

[Anonymous]

Hi @subhadip13 

I cant! the job runs via management console so it cant use any personal spaces.

Regards

Priya

[Anonymous]

hello @subhadip13 

I trid your solution, but it gives me error:

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

Regards

Priya

[Anonymous]

Hi Priya,

   Please refer my comment in the below post for reference.

https://community.talend.com/t5/Design-and-Development/Replacing-invalid-xml-character-Unicode-0xc/m...

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 🙂