XML Output converts " to &quote;

[roy]

Hi All,
I'm extracting a string from Oracle to a XML output stage using UTF-8
A string of

Code: Select all

abc"d

is being translated to

Code: Select all

abc&quote;d

in the output file.
viewing this output via a browser shows the data as

Code: Select all

abc"d

but a validation process is expecting the original string and fails validation.

Is there a way to retain the original string in the xml output file?
Thanks in advance for your time...

[eostic]

Correct the vendor who is receiving the document. Quotes and other special characters need to be escaped. That is proper handling of the xml and working by design within the xmlOutput Stage.

As a solution, though dangerous (what "other" escape possibilities is this application ignoring?) is to send the xmlOutput content to a single column (create a large column on your output link, like "myXMLcontent" with varchar and length of 99999 or similar) and put a single slash "/" in the Description. Send that into a Transformer and just use something like ereplace() to zap all of the items you don't want back into whatever you need...

Ernie

[chulett]

Sorry but what "validation process is expecting the original"? As noted by Ernie that is completely correct and perfectly valid XML.

[roy]

Thanks for the replies guys!

Eventually I ended up using the new(er) XML stage which got me to the desired non escaped context and with no line breaks between tags and data.

[eostic]

Thanks. In some contexts, that could be considered a bug. Proper behavior is to perform the escape. I haven't checked in awhile....the hierarchical stage may only do it when validation on input is used.

Ernie