snowflake.snowpark.functions.instr¶

snowflake.snowpark.functions.instr(str: Union[Column, str], substr: str)[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.48.0/src/snowflake/snowpark/functions.py#L12118-L12131)¶

Locate the position of the first occurrence of substr column in the given string. Returns null if either of the arguments are null.

Example::

>>> df = session.create_dataframe([["hello world"], ["world hello"]], schema=["text"])
>>> df.select(instr(col("text"), "world").alias("position")).collect()
[Row(POSITION=7), Row(POSITION=1)]