Home > IT Answers > Development > How to remove the values of xml tags null without removing the tag names?
Serenewebster
5 pts.
 How to remove the values of xml tags null without removing the tag names?
MSXML.DOMDocument, NULL values, XML
Hi, I have the following xml : ... .... <A> <B> <C>11122</C> <D>loop</D> <E>30-03-05</E> <F>integer</F> <G>decimal</G> <H /> </B> </A> ... .... I need to remove all the values under <payment_details> so that the xml will be in the desired format as below: ... .... <A> <B> <C></C> <D></D> <E></E> <F></F> <G></G> <H /> </B> </A> ... .... My code is : 
Set xmlDoc = CreateObject("MSXML.DOMDocument")

       xmlDoc.async = False
       xmlDoc.loadXML ("test.xml")
       
      Set xmlnodeval = xmlDoc.selectSingleNode("../../A")
   
       If False = (xmlNode8 Is Nothing) Then

             xmlnodeval.Text = ""
       End If
But this code removes all the tag names as well and the <A> tag is just shown as </A> without the inner tag names.How can I achieve the desired format mentioned above through this code. Thank you

Software/Hardware used:
ASKED: June 25, 2009  12:00 PM
UPDATED: June 25, 2009  12:13 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _