snowflake.snowpark.functions.regexp_extract¶
- snowflake.snowpark.functions.regexp_extract(value: Union[Column, str], regexp: Union[Column, str], idx: int) Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/functions.py#L2684-L2711)¶
Extract a specific group matched by a regex, from the specified string column. If the regex did not match, or the specified group did not match, an empty string is returned.
Example:
>>> from snowflake.snowpark.functions import regexp_extract >>> df = session.createDataFrame([["id_20_30", 10], ["id_40_50", 30]], ["id", "age"]) >>> df.select(regexp_extract("id", r"(\d+)", 1).alias("RES")).show() --------- |"RES" | --------- |20 | |40 | ---------