Replace
Quick find and replace for simple values. Can use regex if 'input' in params and isinstance(params['input'], list):in the find field.
Quick find and replace for simple values. Can use regex in the find field.
note
Values that are not a number or a string pass through unaltered.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
input | Name or list of input column. | string, integer, array | — | Yes |
output | Name or list of output column. | string, array, null | null | No |
| Options | ||||
find | Pattern to find using regex. | string | — | Yes |
replace | Value to replace the pattern found. | string | — | Yes |
| Conditions | ||||
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
Examples
wrangles:
- replace:
input: Product Data
find: brg
replace: bearing
| Product Data |
|---|
| SKF ball brg |
| brg seal |
| Product Data |
|---|
| SKF ball bearing |
| bearing seal |
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 90 |
| Catalog key | replace |
| Recipe key | replace |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | Root-level |
| Documentation group | format |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.main.replace |
| Legacy UUID | f0ab715e-9e0e-4614-83e4-5cd8ea08a09f |
Sources