snowflake.snowpark.functions.position¶

snowflake.snowpark.functions.position(expr1: Union[Column, str], expr2: Union[Column, str], start_pos: int = 1) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.45.0/src/snowflake/snowpark/functions.py#L11712-L11743)¶

Searches for the first occurrence of the first argument in the second argument and, if successful, returns the position (1-based) of the first argument in the second argument.

Example:

CopyExpand

>>> df = session.create_dataframe([['an', 'banana'], ['nan', 'banana']], schema=["expr1", "expr2"])
>>> df.select(position(df["expr1"], df["expr2"], 3).alias("position")).collect()
[Row(POSITION=4), Row(POSITION=3)]

Show lessSee more

Scroll to top