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.  Like Search using LOOKUP or EXTRACT

    Posted 07/02/09 03:15 PM

    Originally posted by: SystemAdmin


    I need to retrieve based on statuses that starts with text CLOSED.
    How do i use 'CLOSED%' condition in EXTRACT or LOOKUP functions ?
    i.e
    EXTRACT(Status:In1, Status:In1="CLOSED")

    For example above returns all Status that are equal to CLOSED. But I need to retrieve all the Status that starts with CLOSED.

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


  • 2.  Re: Like Search using LOOKUP or EXTRACT

    Posted 07/02/09 03:23 PM

    Originally posted by: repanzer


    EXTRACT(Status:In1, LEFT(Status:In1,6)="CLOSED")
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Like Search using LOOKUP or EXTRACT

    Posted 07/07/09 04:48 PM

    Originally posted by: SystemAdmin


    or (EXTRACT(Status:In1, find("CLOSED", Status:In1)> 0 )
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


Related Content