Find & Replace Rule (find_replace
) β
Replaces occurrences of a specified value in a column.
Field | Description | Required |
---|---|---|
find | The text or pattern to search for. | β Yes |
replace | The text to replace matches with. | β Yes |
regex | If true , the find field will be treated as a regular expression. | β No (default: false ) |
Example: β
json
{
"type": "find_replace",
"source_column": "customer_name",
"destination_column": "",
"find": "Inc\.",
"replace": "Incorporated",
"regex": true
}
Behavior: Replaces "Inc." with "Incorporated" in the customer_name
column.