IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
  • 1.  PAD Character According to Input Value

    Posted 04/16/16 09:54 PM

    Originally posted by: Diamond.Li


    Hello,

    Is it possible to achieve this in WTX?

    For example, I have a field called "salary", 10 bytes long

    if input value isn't NULL, such as "1000", WTX uses space as PAD character, result would be:  "      1000"

    if input value is NULL , WTX uses "0" as PAD character, but first character is space, result would be: " 000000000".

    Appreciate for any help!

    Diamond

     


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


  • 2.  Re: PAD Character According to Input Value

    Posted 04/18/16 03:51 AM
      |   view attached

    Originally posted by: paul.brett


    Yes, you can design a Typetree to accept this data.  Several ways in fact.

    By far the easiest, would be to define " 000000000" as a special value for NONE, as per the enclosed example.

    Thank-you.

    Paul.

    Follow me on Twitter


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

    Attachment(s)

    zip
    VarPad.zip   1 KB 1 version


  • 3.  Re: PAD Character According to Input Value

    Posted 04/18/16 09:09 AM

    Originally posted by: Diamond.Li


    Hi Paul, 

    This is a perfect answer and example. Thanks a lot!

    Diamond

     


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