IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
 View Only
Expand all | Collapse all

WTX Map on DataPower replacing CRLF with LF

  • 1.  WTX Map on DataPower replacing CRLF with LF

    Posted Thu June 23, 2016 12:59 AM

    Originally posted by: infyrsp


    We have WTX Map which just extracts a SWIFT MT message from an XML Tag maps the complete message. The Map is converting CRLF into LF when we run it on DataPower. On my local windows machine CRLF is passed as same. Can any one help on this?

     

    Input:

    <swif:Message>{1:F01ANZBAU3MXXXX0001000001}{2:I202BARCGB22XXXXN}{3:{108:1653B40039MV090Z}{119:COV}}{4:
    :20:1653B40039MV090Z
    :21:LQ0E0CC30S6F3104
    :32A:160503GBP1015,15
    :52A:ANZBAU3MXXX
    :57A:BARCGB22XXX
    :58A:CITIFRPPXXX
    :50K:/013950836554445
    Australia and New Zealand Banking G
    roup Limited
    833 Collins Street
    AU/Melbourne
    :52A:ANZBAU3MXXX
    :59:/234674AUD00001
    Some in Melbourne P/L Ltd.
    Level 7, 800 Collins Street
    :70:TEXT IS MORE THAN 35 CHARACTERS. HO
    W DOES IT GET WRAPPED AROUND
    TEXT IS MORE THAN 35 CHARACTERS. HO
    W DOES IT GET WRAPPED AROUND
    :33B:GBP1015,15
    -}</swif:Message>

     

    Output:

    {1:F01ANZBAU3MXXXX0001000001}{2:I202BARCGB22XXXXN}{3:{108:1653B40039MV090Z}{119:COV}}{4:
    :20:1653B40039MV090Z
    :21:LQ0E0CC30S6F3104
    :32A:160503GBP1015,15
    :52A:ANZBAU3MXXX
    :57A:BARCGB22XXX
    :58A:CITIFRPPXXX
    :50K:/013950836554445
    Australia and New Zealand Banking G
    roup Limited
    833 Collins Street
    AU/Melbourne
    :52A:ANZBAU3MXXX
    :59:/234674AUD00001
    Some in Melbourne P/L Ltd.
    Level 7, 800 Collins Street
    :70:TEXT IS MORE THAN 35 CHARACTERS. HO
    W DOES IT GET WRAPPED AROUND
    TEXT IS MORE THAN 35 CHARACTERS. HO
    W DOES IT GET WRAPPED AROUND
    :33B:GBP1015,15


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


  • 2.  Re: WTX Map on DataPower replacing CRLF with LF

    Posted Tue June 28, 2016 08:49 AM

    Originally posted by: paul.brett


    Edit the properties of the Typetree objects, changing any <NL> into <CR><LF>, and you may get the result you need.  It might be best to export the Typetree, and modify the exported data using a search/replace operation in Notepad, then re-import it afterwards.

    Thank-you

    Paul

    Follow me on Twitter


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