topic Re: Talend Mediation Check Xpath Value in Talend Studio

Talend Mediation Check Xpath Value

DDcosta1619866252 — Sat, 16 Nov 2024 00:11:25 GMT

I have an XML which has the below value.

I am using cMessageRouter to check for the value "NEW"

I also used

StringHandling.TRIM("/REQUEST/REQUEST_TYPE/text()").equals("NEW"), but it is not working.

Please tell me how to remove spaces to get it work?

REQUEST_TYPE

value has spaces

<?xml version="1.0" encoding="UTF-8" ?>

<REQUEST_TYPE>

NEW

</REQUEST_TYPE>

</REQUEST>

Re: Talend Mediation Check Xpath Value

DDcosta1619866252 — Wed, 05 May 2021 14:57:46 GMT

@Xiaodi Shi I have posted a query which I am facing but no one is suggested or recommended. Can you please provide some suggestion

Re: Talend Mediation Check Xpath Value

DDcosta1619866252 — Mon, 10 May 2021 10:51:44 GMT

Hi,

did anyone got a chance to look at my query

Thanks,

Dan

Re: Talend Mediation Check Xpath Value

gjeremy1617088143 — Mon, 10 May 2021 14:39:33 GMT

HI, i think your query is not good :

StringHandling.TRIM("/REQUEST/REQUEST_TYPE/text()").equals("NEW") will compare the String "/REQUEST/REQUEST_TYPE/text()" and not the /REQUEST/REQUEST_TYPE/text() value.

Send me Love and Kudos

Re: Talend Mediation Check Xpath Value

gjeremy1617088143 — Mon, 10 May 2021 14:53:15 GMT

maybe "//REQUEST/REQUEST_TYPE[contains(text(),'NEW')]"