Get Element Text Using xml mini dom python

Question

i am trying to get the text of an element using mini dom, in the following code , i have also tried getText() Method as suggested here , but i am unable to get the desired output, following is my code. I dont get the Text value from the element i am trying to work on.

import xml.dom.minidom

doc = xml.dom.minidom.parse("DL_INVOICE_DETAIL_TCB.xml")
results = doc.getElementsByTagName("G_TRANSACTIONS")
def getText(nodelist):
    rc = []
    for node in nodelist:
        if node.nodeType == node.TEXT_NODE:
            rc.append(node.data)
    return ''.join(rc)
for result in results:
    for element in result.getElementsByTagName("INVOICE_NUMBER"):
        print(element.nodeType)
        print(element.nodeValue)

Following is my XML sample

<LIST_G_TRANSACTIONS>
    <G_TRANSACTIONS>
        <INVOICE_NUMBER>31002</INVOICE_NUMBER>
        <TRANSACTION_CLASS>Invoice</TRANSACTION_CLASS>
    </G_TRANSACTIONS>
</LIST_G_TRANSACTIONS>

I am using the following

balderman · Accepted Answer · 2019-09-11 15:40:04Z

1

A minidom based answer

from xml.dom import minidom

xml = """\
<LIST_G_TRANSACTIONS>
    <G_TRANSACTIONS>
        <INVOICE_NUMBER>31002</INVOICE_NUMBER>
        <TRANSACTION_CLASS>Invoice1</TRANSACTION_CLASS>
    </G_TRANSACTIONS>
    <G_TRANSACTIONS>
        <INVOICE_NUMBER>31006</INVOICE_NUMBER>
        <TRANSACTION_CLASS>Invoice2</TRANSACTION_CLASS>
    </G_TRANSACTIONS>    
</LIST_G_TRANSACTIONS>"""

dom = minidom.parseString(xml)
invoice_numbers = [int(x.firstChild.data) for x in dom.getElementsByTagName("INVOICE_NUMBER")]
print(invoice_numbers)

output

[31002, 31006]

answered Sep 11, 2019 at 15:40

balderman

24k8 gold badges39 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

balderman · Accepted Answer · 2019-09-11 15:22:01Z

0

If using ElementTree is fine with you, here is the code:

import xml.etree.ElementTree as ET

xml = '''<LIST_G_TRANSACTIONS>
    <G_TRANSACTIONS>
        <INVOICE_NUMBER>31002</INVOICE_NUMBER>
        <TRANSACTION_CLASS>Invoice1</TRANSACTION_CLASS>
    </G_TRANSACTIONS>
    <G_TRANSACTIONS>
        <INVOICE_NUMBER>31006</INVOICE_NUMBER>
        <TRANSACTION_CLASS>Invoice2</TRANSACTION_CLASS>
    </G_TRANSACTIONS>    
</LIST_G_TRANSACTIONS>'''

root = ET.fromstring(xml)
invoice_numbers = [entry.text for entry in list(root.findall('.//INVOICE_NUMBER'))]
print(invoice_numbers)

output

['31002', '31006']

answered Sep 11, 2019 at 15:22

balderman

24k8 gold badges39 silver badges60 bronze badges

2 Comments

noobie-php Over a year ago

Thanks for the reply, but i need it via mini dom

balderman Over a year ago

Just to let you know, ElementTree is a core python package and not an external package (just like minidom)

Collectives™ on Stack Overflow

Get Element Text Using xml mini dom python

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related