IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
 View Only

  • 1.  TONUMBER function

    Posted Fri May 21, 2004 03:38 AM

    Originally posted by: SystemAdmin


    I am going demented trying to convert a text srting to a formatted number.
    I want to convert 123456.78 to 123,456.78 and I have tried using TONUMBER with all sorts of number_format_strings but I always get the result of 123456.78.
    What is the correct format of the rule?
    Thanks Jan
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: TONUMBER function

    Posted Fri May 21, 2004 05:35 AM

    Originally posted by: SystemAdmin


    No the output is a text field so I need to do a numbertotext(tonumber(number,format))
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 3.  Re: TONUMBER function

    Posted Fri May 21, 2004 07:11 AM

    Originally posted by: SystemAdmin


    Try this:

    =FROMNUMBER(123456.78,"{#','###'.'2##2}")

    results:

    123,456.78
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 4.  Re: TONUMBER function

    Posted Fri May 21, 2004 07:46 AM

    Originally posted by: SystemAdmin


    Since we are starting with a text item... you may have to tweek it to ...

    =FROMNUMBER(TEXTTONUMBER("123456.78"),"{#','###'.'2##2}")
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 5.  Re: TONUMBER function

    Posted Mon May 24, 2004 02:02 AM

    Originally posted by: SystemAdmin


    Thanks that's sorted it.
    Jan
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


Related Content