Topic
  • 4 replies
  • Latest Post - ‏2014-07-03T14:38:11Z by jourdanss
jourdanss
jourdanss
24 Posts

Pinned topic subString in wtx map

‏2014-06-27T20:27:07Z |

Hi, I need help with a subString,

I have this field:

=idDeudor:sequence:solicitud:sequence:entrada_xml

but I want just the two first characters.

How I can do a subString?

I tried that    =SUBSTRING(idDeudor:sequence:solicitud:sequence:entrada_xml,0,2)

Thanks, Jourdan.   

Updated on 2014-06-30T08:13:45Z at 2014-06-30T08:13:45Z by paul.brett
  • RichMcFate
    RichMcFate
    39 Posts

    Re: subString in wtx map

    ‏2014-06-29T19:39:38Z  

    Jourdan -- WTX uses a combination of functions (LEFT, RIGHT, MID) to perform substring operations.

    Try LEFT(idDeudor:sequence:solicitud:sequence:entrada_xml,2)

    For future reference, there's a well-written document that describes all of the functions WTX uses.

    http://pic.dhe.ibm.com/infocenter/wtxdoc/v8r4m1/index.jsp?topic=%2Fcom.ibm.websphere.dtx.funcexp.doc%2Fconcepts%2Fc_funcs_express_Expressions_and_Evaluations.htm

    Rich

  • paul.brett
    paul.brett
    791 Posts

    Re: subString in wtx map

    ‏2014-06-30T15:21:05Z  

    ...and if the Infocenter isn't your cup-o-tea, then perhaps you could peruse the Redbook on IBM WebSphere Transformation Extender:

    IBM WebSphere Transformation Extender 8.2

    It may be for an older version, but it still contains some great information.

    Thank-you.

    Paul.

    Follow me on Twitter

  • jourdanss
    jourdanss
    24 Posts

    Re: subString in wtx map

    ‏2014-07-03T14:36:21Z  

    Jourdan -- WTX uses a combination of functions (LEFT, RIGHT, MID) to perform substring operations.

    Try LEFT(idDeudor:sequence:solicitud:sequence:entrada_xml,2)

    For future reference, there's a well-written document that describes all of the functions WTX uses.

    http://pic.dhe.ibm.com/infocenter/wtxdoc/v8r4m1/index.jsp?topic=%2Fcom.ibm.websphere.dtx.funcexp.doc%2Fconcepts%2Fc_funcs_express_Expressions_and_Evaluations.htm

    Rich

    Thanks Rich, works really well, solve my problem.

    Thanks,

    Jourdan.

  • jourdanss
    jourdanss
    24 Posts

    Re: subString in wtx map

    ‏2014-07-03T14:38:11Z  

    ...and if the Infocenter isn't your cup-o-tea, then perhaps you could peruse the Redbook on IBM WebSphere Transformation Extender:

    IBM WebSphere Transformation Extender 8.2

    It may be for an older version, but it still contains some great information.

    Thank-you.

    Paul.

    Follow me on Twitter

    Thanks for your info Paul, I check it.

    Thanks,

    Jourdan.