IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
 View Only
  • 1.  Suppressing CRLF in output XML

    Posted Thu March 19, 2015 04:09 PM

    Originally posted by: Budman


    Good Day.

    One of our Message Broker implementations hosts two distinct flows, each with a separate map. Each map represents an EDIFACT to XML transformation.

    One map produces no CRLF within the produced XML.  The other DOES.   Need to know how to remove the CRLF.

    ANY feedback appreciated.

    Thanks!


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


  • 2.  Re: Suppressing CRLF in output XML

    Posted Fri March 20, 2015 07:14 AM

    Originally posted by: paul.brett


    Do you have access to the source files for the map?  I would guess that a small change to the output card's Typetree would allow you to achieve what you need.

    Thank-you.

    Paul.

    Follow me on Twitter


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


  • 3.  Re: Suppressing CRLF in output XML

    Posted Fri March 20, 2015 07:20 AM
      |   view attached

    Originally posted by: paul.brett


    In the enclosed sample, the same XML is produced using WTX in two different ways.

    In output card #1, I used a Typetree (imported from the Schema)

    In output card #2, I used the Schema directly.

    As you can see, Output2.xml includes CR/LFs, whereas Output1.xml does not.

    If you just need to 'strip' all CR/LFs out of the output, it would be easy to do this with a very simple post-processing map, which uses a rule such as:

    =SUBSTITUTE(Input1,"<NL>","")

    Thank-you.

    Paul.

    Follow me on Twitter


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

    Attachment(s)

    zip
    xml.zip   2 KB 1 version


  • 4.  Re: Suppressing CRLF in output XML

    Posted Fri March 20, 2015 09:42 AM

    Originally posted by: Budman


    Thanks, Paul.  I am going to attempt to try to put together the 'post' processing map as you suggest (never done such a  thing before). 

    If there is ANY way to strip the CRLF in the output card typetree definition, i would be most interested in that.  For certain I have searched vigorously to find such.

    Will await your reply and possible tip as to how to build the post-process map.

    Thank you for your feedback.


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


  • 5.  Re: Suppressing CRLF in output XML

    Posted Fri March 20, 2015 11:27 AM
      |   view attached

    Originally posted by: paul.brett


    It all depends on the output card, and if it uses a real Typetree, or the native XSD file.  If it just the Typetree, then this could be edited, to remove the CRLFs (a tedious task but one that could possibly be done with scripting).

    If the output card uses the XSD, then you're out of luck.  The format is the format.,

    A simple StripCRLF example is attached.

    Thank-you.

    Paul.

    Follow me on Twitter


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

    Attachment(s)

    zip
    StripCRLF.zip   5 KB 1 version