snowflake.snowpark.functions.xpath_number¶

snowflake.snowpark.functions.xpath_number(col: Union[Column, str], path: str) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.47.0/src/snowflake/snowpark/functions.py#L12294-L12321)¶

Extracts a numeric value from an XML column using an XPath expression.

Returns NULL if no matches are found or value cannot be converted to float.

Parameters:

• col – Column containing XML data

• path – XPath expression string

Example:

CopyExpand

>>> df = session.create_dataframe([['<root><price>19.99</price></root>']], schema=['xml'])
>>> df.select(xpath_number('xml', '//price/text()').alias('price')).collect()
[Row(PRICE=19.99)]

Show lessSee more

Scroll to top