IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
Expand all | Collapse all

How to read special characters in xml data in WTX?

  • 1.  How to read special characters in xml data in WTX?

    Posted Fri April 29, 2016 06:01 AM

    Originally posted by: steverats


    Hi,

     

    My xml structure is like,

    <a>

    <b>

    <c>stev & rats</c> 

    </b>

    </a>

     

    when I am validating the input . It was showing the error as "INVALID data". at <c> stev & rats</c>

     

    How can I validate this data?

     

    Thanks,

     


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: How to read special characters in xml data in WTX?

    Posted Fri April 29, 2016 07:29 AM

    Originally posted by: Ejay


    Hi,

    The '&' character is itself an escape character in XML

    Are you able to validate this ?

    <a>

    <b>

    <c>stev &amp; rats</c> 

    </b>

    </a>

    If yes you might need to escape & or replace it by &amp; in your data .

     

    Ejay

     


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: How to read special characters in xml data in WTX?

    Posted Fri April 29, 2016 07:35 AM

    Originally posted by: steverats


    Thanks for the quick reply.

     

    yes, I can read &amp;

     

    How can I escape that & character? (without modifying the data)


    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender