topic XML escape character in Talend Studio

XML escape character

_AnonymousUser — Sat, 16 Nov 2024 14:35:21 GMT

I use the tFileOutputXML to generate an XML file from a MSSQL database.
The XML is generated but is not valid in any XML editor.
In fact all special character (<,>,&, ', ") are not escaped. So the XML is not usable.

Is there any simple solution integrated in TALEND to escape.
< < less than
> > greater than
& & ampersand
' ' apostrophe
" " quotation mark

It's not possible to make this transformation in a tMap component because it will
need to transform all the fields.

Thanks
Regards

Re: XML escape character

Anonymous — Mon, 02 Jul 2007 16:43:11 GMT

Hello
Can you precise your TOS Version and your project language ?
Michaël.

Re: XML escape character

_AnonymousUser — Mon, 02 Jul 2007 16:43:58 GMT

TOS 2.1.0 M2 and Java language.

Re: XML escape character

Anonymous — Mon, 02 Jul 2007 18:09:40 GMT

Yes you're right.
As a work around, you can call a mapper before the tFileOutputXML and make this transformation on your columns : TalendString.replaceSpecialCharForXML(myRow.myCol);
Regards,

Re: XML escape character

Anonymous — Mon, 02 Jul 2007 22:54:46 GMT

Are there any plans to make this available through the GUI in the future? We have customers that need to export to XML but won't code in Java.
Thanks,
Jason

Re: XML escape character

Anonymous — Mon, 02 Jul 2007 23:24:43 GMT

Remenber that 2.1.0M2 is only a Milestone version.
This bug is a regression, values were automatically parsed in 2.0.XX version.
This will be corrected in 2.1 RC1 (Release Candidate 1)
Regards,

Re: XML escape character

_AnonymousUser — Tue, 03 Jul 2007 07:56:05 GMT

OK thanks for this correction in the RC1
I've opened an issue in Mantis to follow.

Regards

Re: XML escape character

_AnonymousUser — Thu, 02 Feb 2017 10:57:21 GMT

Hi ,
This is not working for me.