Extract data between specific xml elements in a clob

umashankarus — Mon, 13 Dec 2021 15:11:34 GMT

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

Re: Extract data between specific xml elements in a clob

chrismarlow — Mon, 13 Dec 2021 17:45:01 GMT

Hi,

Have you seen this thread;

Cheers,

Chris.