Looking for a REPLACE function?
Replace functions are commonly used to find specific values and replace them with other values. A simple example is to find a state abbreviation (TX) and replace it with it's full name (Texas). In data practices, replace functions are used to help clean or standardize data (i.e., remove unwanted characters, standardize conventions, etc.).
In Unify, you can use the REGEXP_REPLACE function in a SQL Query Transformation to replace values. In the below example, I'm replacing a comma (,) and number sign (#) in the Stream column to create a new column StreamClean.
The REGEXP_REPLACE function is constructed using the below convention.