Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 & when i create the xml file .. how can i solve this
i need the xml file to be created with
& and not &
Hi
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
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 
.
 , 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
Hi
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 & with &, the same processing for other special characters.
Regards
Shong