Originally posted by: SystemAdmin
WTX 8.3.04
My map has 2 output cards. The first output card is non-XML and contains multiple rows of 2 values (quoted and comma-delimited) like so:
"COMPANY NUM","COMAPNY NAME"
"0001","A & B Trucking"
"0002","Crandall <Brothers> Flowers"
"0003","Anderson Auto"
The 2nd output card is XML-based, and the contents of the 1st output card is used to populate one of its XML elements like so:
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Header></Header>
<Body>
<Response>
<TargetObject>"COMPANY NUM","COMPANY NAME"
"0001","A & B Trucking"
"0002","Crandall <Brothers> Flowers"
"0003","Anderson Auto"
</TargetObject>
</Response>
</Body>
</Envelope>
But what I'd like to see is:
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Header></Header>
<Body>
<Response>
<TargetObject>"COMPANY NUM","COMPANY NAME"
"0001","A & B Trucking"
"0002","Crandall <Brothers> Flowers"
"0003","Anderson Auto"
</TargetObject>
</Response>
</Body>
</Envelope>
I've experimented with the Exclude Character Restriction and used the Reference string, but the result is the same. I cannot get an & in the output, it's being escaped.
Does the xmlsimp.xml file come into play, by overriding the value and translating the & to the escaped value?
Any help you be appreciated.
#DataExchange#IBM-Websphere-Transformation-Extender#IBMSterlingTransformationExtender