Find And Replace
Description
Replaces values in the data with the replacement values specified by the user. Users can also set specific rules for selected columns to apply the transformation.
Input
Data only
Output
Transformed Data
Configuration Fields
Column Map
A set of rules to match the values in the data.
-
Column Name
Specifies the column name to set the rules for. -
Matching Mode
Determines how the matching is performed- Complete Value
- Substring
- Regex Pattern
-
Matching Case
Defines the case sensitivity of the match- Case-Sensitive
- Case-Insensitive
Replacement
Specifies the pairs of values in the data and their corresponding replacement values.
-
Find
Specifies the value in the data to be replaced. -
Replace
Specifies the replacement value for the corresponding “Find” value.
Sample Input
| product_id | product_name | brand_names |
|---|---|---|
| P001 | Smartphone | Apple, Samsung, Google |
| P002 | Laptop | Dell, HP, Lenovo |
| P003 | Headphones | Bose, Sony, Sennheiser |
| P004 | TV | LG, Samsung, Sony |
| P005 | Smartwatch | Fitbit, Garmin, Apple |
Sample Configuration
Sample Output
| product_id | product_name | brand_names |
|---|---|---|
| P001 | Smartphone | Apple, Samsung, Google |
| P002 | Laptop | HP, HP, Lenovo |
| P003 | Headphones | Bose, Sony, Sennheiser |
| P004 | TV | LG, Samsung, Sony |
| P005 | Smartwatch | Fastrack, Garmin, Apple |