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 manner:
= 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
<?xml version=""1.0"" encoding=""UTF-8""?>
the quotes should be"
instead of""
.