I'm struggling to get the value of an XML node using the FilterXML() function when the XML document's document element has a namespace specified.
Example:
<?xml version="1.0" encoding="UTF-8"?>
<DocumentElement xmlns="XMLSchemaDefinition.xsd">
<Field>
<Value>100</Value>
</Field>
</DocumentElement>
= FILTERXML(A1, "/Document/Element/Value[1]")
I managed to get FilterXML working by removing the namespace in the following maer:
= FILTERXML(SUBSTITUTE(A1, "<DocumentElement xmlns=""XMLSchemaDefinition.xsd"">", "<DocumentElement>"), "/DocumentElement/Field/Value[1]")
Is there a way to get the value of the XML node without having to remove the namespace(s)?
I'm currently using LibreOffice Version: 5.0.5.2
- - , .
برچسب:
نویسنده: استخدام کار