> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Replacement rules transform in ELT & CDC

> Use replacement rules in Integrate.io ELT & CDC to transform data during replication. Replace, mask, or modify character values during sync.

## Usage

The Replacement Rule feature allows you to replace certain characters during your data transfer. 

You may have a column that contains data you want to remove or hide before transferring to your destination. You can define a replacement rule for that column, and replace all values before loading them into your target destination.

* Replacement Rules is specific to a pipeline and needs 4 things
  * Collection/Table - e.g. `Test.Employees (source/db.table_name)`
    * Column - e.g. `Name`
    * Find (Regex) - `^\w+`
    * Replace (String) - \`\*\*\*\`
* So `How are you?` → `*** are you?`

Contact Integrate.io Support team if you wish to apply transformation by replacement rule to your pipeline.