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
XML '
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Set data element as XML in you column property.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Re: XML '
This looks only in the UNIX environment, when you look in the windows environment with internet explorer it will look fine.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
I noticed yours is a windows environment, I guess if you open in Internet explorer it should be fine toooo.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Re: XML '
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.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
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
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