topic Re: tAdvancedXMLFileOutputXML , XML , special XML characters in Talend Studio

tAdvancedXMLFileOutputXML , XML , special XML characters

Mehdi_Mhedhbi2 — Fri, 15 Nov 2024 23:53:24 GMT

Hello Every One

im reading data from an sql server table , some fields contains special XML characters like

&,<, >

im reading the data to create a complexe XML file with multiple tAdvancedXMLFileOutputXML components using the append option

for exemple the & caracter is transforming to &amp when i create the xml file .. how can i solve this

i need the xml file to be created with

& and not &

Re: tAdvancedXMLFileOutputXML , XML , special XML characters

Anonymous — Tue, 10 Aug 2021 10:01:22 GMT

The special characters such as "<", ">" are always transformed automatically by tAdvancedFileOutputXML component, if you open the XML file in a browser, you will see it displays correctly.

Best regards

Shong

Re: tAdvancedXMLFileOutputXML , XML , special XML characters

Mehdi_Mhedhbi2 — Fri, 13 Aug 2021 07:40:42 GMT

yes , but i am using the content of the XML file to call a soap web service and these special caracter are transforming .

to explain better i have this the DB (sql server ) from which im reading data char(10) as &#10.&#13 , when i apply the soap call this should be

translated to CR but it is not because & is changing to &, same thing happend if i put them in a CDATA

Re: tAdvancedXMLFileOutputXML , XML , special XML characters

Anonymous — Fri, 13 Aug 2021 07:54:05 GMT

You can do nothing unless you change the source code of tAdvancedXMLFileOutputXML. One idea: After generate the XML file, read the file content as a sting using tFileInputRaw component and replace all &amp with &, the same processing for other special characters.

Regards

Shong