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.  Function to pad?

    Posted 06/07/11 08:08 AM

    Originally posted by: Jaango


    What function can be used to pad integres to fixed length of 4. if the integer is 0, after padding it should be 0000. 15 should be 0015. We want to use functions only.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: Function to pad?

    Posted 06/07/11 10:34 AM

    Originally posted by: TarunB


    Try FILLLEFT, though you may need to combine this with FROMNUMBER/TONUMBER depending on your field format.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Function to pad?

    Posted 06/08/11 06:46 AM

    Originally posted by: Jaango


    Thanks, Tarun
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


Related Content