IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
Expand all | Collapse all

Substring After & Before Equivalent

  • 1.  Substring After & Before Equivalent

    Posted 09/02/14 10:08 PM

    Originally posted by: RubenRandall


    Hi Experts,

    I am having a requirement where I am getting a value like this (firstName=Ruben) as field value, I was wondering If there is an equivalent WTX function that can split up the value in to two parts before and after '=' sign - just like XSLT function substring-before() & substring-after() and assign these two values to two different fields in output card.

    Please let me know if there is any equivalent or work around to achieve this

    Thanks,

    Ruben


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


  • 2.  Re: Substring After & Before Equivalent

    Posted 09/03/14 12:26 AM

    Originally posted by: wtx_genie


    Hi, Try this

    =WORD( Input, "=", 1)  // for populating before value

    =WORD( Input, "=", 2)  // for populating after value.

    Regards,

    wtxgenie


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