To extract xml file(tags) inside the CDATA section of Response

Summary

To extract xml file(tags) inside the CDATA section of Response

Content

I have the scenario to extract the xml tags present inside the CDATA section of Response(one of inline response). Need to exclude the CDATA to fetch the xml tags to be inputted to other integration. Sample tags which i need to convert is:

<result><![CDATA[<?xml version = '1.0' encoding = 'utf-8'?>

<!--Generated by Oracle BI Publisher 11.1.1.9.0 -Dataengine, datamodel:__immanuvel_nizanth__temp_366a0388_df28_48cc_99e0_ca63d42f753d_xdm -->

<DATA_DS>

<G_1>

<USER_ID>300000001209506</USER_ID><USERNAME>IDROUser</USERNAME>

</G_1>

<G_1>

<USER_ID>300000001209495</USER_ID><USERNAME>orcladmin</USERNAME>