Talend Mediation Check Xpath Value

[DDcosta1619866252]

Hi

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?

My

REQUEST_TYPE

value has spaces

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

<REQUEST>

<REQUEST_TYPE>

  NEW

</REQUEST_TYPE>

</REQUEST>

[DDcosta1619866252]

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

[DDcosta1619866252]

Hi,

did anyone got a chance to look at my query

Thanks,

Dan

[gjeremy1617088143]

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

[gjeremy1617088143]

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