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.  Convert function for packed binary number to text.

    Posted 04/30/12 07:59 AM

    Originally posted by: SystemAdmin


    Hi,
    I have following data in my input card

    Class - Item
    Item subclass - Number
    Interpret as - Binary
    Presentation - Packed
    Length(bytest) - 3

    I want to convert it to text
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Convert function for packed binary number to text.

    Posted 04/30/12 08:15 AM

    Originally posted by: richlee


    Use the NUMBERTOTEXT function.

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


  • 3.  Re: Convert function for packed binary number to text.

    Posted 05/04/12 02:50 AM

    Originally posted by: SystemAdmin


    I tried number to text but that did not work. Wanted to know if I need to use any of the below functions :
    PACK , BCDTOINT etc
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: Convert function for packed binary number to text.

    Posted 05/04/12 03:01 AM

    Originally posted by: richlee


    Hi,

    Have a look at Chapter 8 (Conversion Functions) in the "Functions and Expressions" document (1006.pdf). PACK won't do it - that's integer to packed decimal. BCDTOTEXT might be an option though.

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


Related Content