Please Sign In or Register to join the Community to see more content!

Looking for a REPLACE function?

adam_element Alumni Posts: 9
edited April 2022 in Templates and Pipelines

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.