I have been browsing on the web on how to extract / determine the namespaces in the xml document given that the xml documetns are coming from different clients and there’s no standard content format, it took me a lot of days browsing to find the answer but no luck, what i found was only how to add/remove. So, what i did was experimenting / exploring the XmlDocument Object on my own, and fortunately, I found it.
Here’s the sample script on vb.net
‘Declare a variables
Dim nm as XmlNamespaceManager
Dim doc as new XmlDocument()
Dim root as XmlNode
doc.load(“c:\xml\test.xml”) ‘ xml path
nm = new XmlNamespaceManager(doc.NameTable);
Here’s the tricky part, you need to extract the attributes of the root document and iterate them.
root = doc.DocumentElement ’get the root document
for i as integer =0 to root.Attributes.count -1
if roo.Attributes(i).Prefix.tolower() = “xmlns” then ‘check if namespace
nm.AddNamespace (roo.Attributes(i).LocalName, roo.Attributes(i).Value)
endif
next
That’s it..