Python - removing xml tag in an element

Question

I am using python 2.7.2. and dom parser to read the data on several xml files. And export .db file to use on sql server. I have learned how to export the files, but XML tags are also included on my data tables. Here is the basic code :

from xml.dom import minidom
import sqlite3
xmldoc = minidom.parse('c:\dd\l2con\l2connection.xml')
coId = xmldoc.getElementsByTagName('id')

and each element are like this :

>>> coId[0]
<DOM Element: id at 0x249cf30>
>>> print coId[0].toxml()
<id>45859</id>
>>> coId[1]
<DOM Element: id at 0x24ac328>
>>> print coId[1].toxml()
<id>46889</id>
>>>

where they should look like this: without the xml tags

>coId[0].toxml()
45859
>coId[1].toxml()
46889

Deleting the tags from xml probably won't work for this case.This way python can't read the xml file. Is there any way you can advise me on this subject.Any help will be appreciated.

Thank You

Yusuf

mzjn · Accepted Answer · 2011-07-13 20:23:22Z

3

coId[0] is a DOM Element with one child (a Text node). Use

coId[0].firstChild.data

to get the text content.

This works too:

coId[0].firstChild.nodeValue

edited Jul 13, 2011 at 20:23

answered Jul 13, 2011 at 19:25

mzjn

51.5k16 gold badges139 silver badges265 bronze badges

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

1 Comment

dorsalfin Over a year ago

thank you I have the correct values now. ` >>> coId[0].firstChild.data u'45859' >>> coId[0].firstChild.nodeValue u'45859' `

Community · Accepted Answer · 2017-05-23 10:24:32Z

2

use coId[0].data instead, this gives the element content.

See mzjn answer, coId[0].firstChild.data is the correct way to do it.

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Jul 13, 2011 at 14:23

CharlesB

91.2k29 gold badges203 silver badges228 bronze badges

4 Comments

mzjn Over a year ago

This can't work. DOM Element instances do not have a data attribute.

mzjn Over a year ago

Elements have a nodeValue attribute, but it returns None.

CharlesB Over a year ago

OK, linked to your answer then.

dorsalfin Over a year ago

coId[0].data gives this error. AttributeError: Element instance has no attribute .data worked for other elements in similar project thanks

Matt · Accepted Answer · 2012-06-26 14:57:02Z

0

You could use/try the nodeValue attribute

Let's assume that you have:

myNode.toXml()= <name>Ben</name>

then

myNode.nodeValue = Ben

edited Jun 26, 2012 at 14:57

Matt

75.4k26 gold badges156 silver badges181 bronze badges

answered Jul 13, 2011 at 14:27

Paronax

13 bronze badges

Collectives™ on Stack Overflow

Python - removing xml tag in an element

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related