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.  Replacing characters in a text field

    Posted 09/08/05 12:20 AM

    Originally posted by: SystemAdmin


    Hello
    How I replace characters in a text field based on position - not value.
    Basically what I am trying to do is replace whatever is in position 1589-1590 with 2 blankspaces.

    Thank you.
    Alex
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Replacing characters in a text field

    Posted 09/08/05 12:41 AM

    Originally posted by: SystemAdmin


    I dont think there is such a function, but you can do it like this:

    =LEFT(field, 1588) + " " + RIGHT(field, SIZE(field)-1590)

    If it is more complicated use MID in combination with FIND if needed.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Replacing characters in a text field

    Posted 09/08/05 02:25 AM

    Originally posted by: SystemAdmin


    Thank you.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


Related Content