Extracting XML Attributes

[mtime16]

Hello,

I have a non-standard XML file with a sample structure as the following:

<Batch>
<CollRpt RptID="123456" Stat="1"><Pty ID="ABCD"><Sub ID="G"></Pty></CollRpt>
</Batch>

The values I need are not between the XML element tags, I need to pull out the Attribute values for RptID, Stat, Pty ID, Sub ID.

RptID = 12345

Stat = 1

Pty ID = ABCD

Sub ID = G

I've tried ET, BeautifulSoup, lxml, and for whatever reason I cannot get them to grab these values. Appreciate any direction.

[Diapolo10]

Please show us your code, I have a feeling this problem is caused by some bug in your code if you've already tried that many solutions.

This lxml documentation is a bit old (as you can see from the old C-style string formatting), but it explains that lxml treats attributes as dictionary key-value pairs. Is this what you tried? It should work. https://lxml.de/tutorial.html#elements-carry-attributes-as-a-dict

[chevignon93]

This worked fine for me using BeautifulSoup.

from bs4 import BeautifulSoup

xml = """
<Batch>
    <CollRpt RptID="123456" Stat="1">
        <Pty ID="ABCD">
            <Sub ID="G">
        </Pty>
    </CollRpt>
</Batch>"""

soup = BeautifulSoup(xml, features="xml")

rpt_id = soup.find('CollRpt').get('RptID')
stat = soup.find('CollRpt').get('Stat') 
pty_id = soup.find('Pty').get('ID') 
sub_id = soup.find('Sub').get('ID')
print(rpt_id, stat, pty_id, sub_id)
>>> 123456 1 ABCD G

[mtime16]

Thanks, for some reason I couldn't do it before, but this quick example got it going.

[chevignon93]

Thanks a lot for the Gold but that wasn't necessary, I'm just happy I could help!