Standardize Clean
Repair common encoding, Unicode, HTML character reference, control character, and whitespace problems locally.
Behavior
Repair common encoding, Unicode, HTML character reference, control character, and whitespace problems locally.
This guidance was derived from the callable signature and its embedded Python schema docstring.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
input | Name or list of input columns. | string, integer, array | — | Yes |
output | Name or list of output columns. Defaults to overwriting input. | string, integer, array, null | null | No |
| Options | ||||
fix_encoding | Repair mojibake and other reversible encoding errors. | boolean | true | No |
unescape_html | Decode HTML character references. Auto avoids decoding text that appears to contain HTML markup. | boolean or string; one of:
| "auto" | No |
normalization | Unicode normalization form. | string; one of:
| "NFC" | No |
fix_character_width | Normalize fullwidth and halfwidth characters. | boolean | true | No |
uncurl_quotes | Replace typographic quotes with straight quotes. | boolean | true | No |
remove_control_chars | Remove C0 and C1 control characters. | boolean | true | No |
collapse_whitespace | Collapse runs of Unicode whitespace. | boolean | true | No |
preserve_line_breaks | Preserve line breaks while collapsing other whitespace. | boolean | false | No |
trim | Remove leading and trailing whitespace. | boolean | true | No |
| Formatting | ||||
separator | Text used to join multiple input columns into one output. | string | " " | No |
| 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 |
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 67 |
| Catalog key | standardize.clean |
| Recipe key | standardize.clean |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | standardize |
| Documentation group | standardize |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.standardize.clean |
| Legacy UUID | None |
Sources