DSXchange

Hi All, how do I get datastage to output apostrosphe ' instead of ' in my XML output. For example I want St john's but data stage is outputting
St John's . Is there a way to override it?



Thanks

Set data element as XML in you column property.

tiozzo wrote:Hi All, how do I get datastage to output apostrosphe ' instead of ' in my XML output. For example I want St john's but data stage is outputting
St John's . Is there a way to override it?
Thanks

This looks only in the UNIX environment, when you look in the windows environment with internet explorer it will look fine.
I noticed yours is a windows environment, I guess if you open in Internet explorer it should be fine toooo.

This is not about viewing. Real data in the output file is what OP is talking about.

prasad111 wrote: This looks only in the UNIX environment, when you look in the windows environment with internet explorer it will look fine.
I noticed yours is a windows environment, I guess if you open in Internet explorer it should be fine toooo.

Another question would be "why does it matter?". What tool or "thing" is reading the XML? It's perfectly valid (and preferred) to escape quotes in this fashion.

Here is a note directly from the XML specification:

=======
To allow attribute values to contain both single and double quotes, the apostrophe or single-quote character (') may be represented as "'", and the double-quote character (") as """.
=======

It's more flexible, and as noted by prasad111, IE understands it, as should any other tool that claims to understand standard XML content.

Ernie

Has anyone figured out how to output the actual apostrophe character to XML using the XML stage? Our target system is not interpretting the "'" text properly, so they want the actual apostrophe character.

Of course, I completely understand and agree with the post above.

As noted above, set the data element to 'XML' for that field and it will pass it through unchanged.