Extract data between specific xml elements in a clob

[umashankarus]

Hi Experts,

I have a clob field which has the data stored with XML formatting

And I wanted to extract specific data (expiry date value) from that field

Below is an excerpt from the clob field

.......

<NAME>EXPIRY_DATE</NAME>
<VALUE>04/15/2022</VALUE>

......

In the above example, the <NAME> and <VALUE> are in different lines

and using the below is not fetching the expected date value

TextBetween(MESSAGE,'<NAME>EXPIRY_DATE</NAME><VALUE>','</VALUE>')

Can you please provide inputs to extract the data ?

Thanks,

Umashankar

[chrismarlow]

Hi,

Have you seen this thread;

Solved: XML Parse - embedded XML - example attached - Qlik Community - 1685144

Cheers,

Chris.