Originally posted by: jourdanss

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.   

Originally posted by: RichMcFate

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

Originally posted by: jourdanss

Thanks Rich, works really well, solve my problem.

Thanks,

Jourdan.

Originally posted by: paul.brett

...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

Originally posted by: jourdanss

Thanks for your info Paul, I check it.

Thanks,

Jourdan.