XPath
The XPath() function reads data from the given XML string for the provided xpath expression. If there are multiple nodes returned then only value from the first node is retrieved.
XPath(xml,xpath);Function arguments
Dział zatytułowany „Function arguments”- xml – (String) XML string with data;
- xpath – (String) xpath expression.
Return value
Dział zatytułowany „Return value”This function returns String. It returns a result of the given xpath expression.
Examples
Dział zatytułowany „Examples”Example 1: XPath() returns inner text from the first number tag inside the first invoice tag from an xml string stored in [XML] field.
XPath([XML], "/invoice/number");Example 2: XPath() returns a value of the number attribute from the first invoice tag from an xml string stored in [XML] field.
XPath([XML], "/invoice/@number");Example 3: XPath() returns inner text from price tag from the invoice tag with number attribute equal 1 from an xml string stored in [XML] field.
XPath([XML], "/invoice[@number='1']/price");