خرید بک لینک

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

- - , .

برچسب: نویسنده: استخدام کار تاريخ: شنبه 15 اسفند 1394 ساعت: 11:46

صفحه بندی