snowflake.snowpark.functions.replace¶

snowflake.snowpark.functions.replace(subject: ColumnOrName, pattern: ColumnOrLiteralStr, replacement: ColumnOrLiteralStr = '') → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L1876-L1901)¶

Removes all occurrences of a specified subject and optionally replaces them with replacement.

Example:

CopyExpand

>>> df = session.create_dataframe([["apple"], ["apple pie"], ["apple juice"]], schema=["a"])
>>> df.select(replace(col("a"), "apple", "orange").alias("result")).show()
----------------
|"RESULT"      |
----------------
|orange        |
|orange pie    |
|orange juice  |
----------------

Show lessSee more

Scroll to top