How to traverse this xml and modify the node

[EDN Admin]

Hi,
I am kind of stuck how to replace some portion of xml with blank space.
Please find below how xml looks like :
<pre><SQLStatement>
<msxt:Choose>
<When>
<Test>not ("MSXT__RT__//PARAMS/ems_03/Value__MSXT" = "")</Test>
SET ROWCOUNT MSXT__RT__//PARAMS/ems_03/Value__MSXT
</When>
</msxt:Choose>
SELECT DISTINCT
<msxt:Choose>
<When>
<Test>not ("MSXT__RT__//PARAMS/ems_01/Value__MSXT" = "")</Test>
MSXT__RT__//PARAMS/ems_01/Value__MSXT
</When>
<When>
<Test>("MSXT__RT__//PARAMS/ems_01/Value__MSXT" = "")</Test>
MSXT__RT__//Dictionary/SelectListDefault/Value__MSXT
</When>
</msxt:Choose>
[/code]
In the above code , I want to replace the below piece of code with empty space
<msxt:Choose><br/>
<When><br/>
<Test>not ("MSXT__RT__//PARAMS/ems_03/Value__MSXT" = "")</Test><br/>
SET ROWCOUNT MSXT__RT__//PARAMS/ems_03/Value__MSXT<br/>
</When><br/>
</msxt:Choose>
Please provide your suggestions as it would be very helpful.

View the full article