strip_column
Remove whitespace or specific characters from column values in CSV data to clean and standardize text fields for analysis.
Instructions
Strip whitespace or specified characters from column values.
Returns: ColumnOperationResult with strip details
Examples: # Remove leading/trailing whitespace strip_column(ctx, "name")
# Remove specific characters
strip_column(ctx, "phone", "()")
# Clean currency values
strip_column(ctx, "price", "$,")
# Remove quotes
strip_column(ctx, "quoted_text", "'\"")Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | Column name to strip characters from | |
| chars | No | Characters to strip (None for whitespace, string for specific chars) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| success | No | Whether operation completed successfully | |
| operation | Yes | Type of operation performed | |
| transform | No | Transform description | |
| part_index | No | Part index for split operations | |
| nulls_filled | No | Number of null values filled | |
| rows_removed | No | Number of rows removed (for remove_duplicates) | |
| rows_affected | Yes | Number of rows affected by operation | |
| values_filled | No | Number of values filled (for fill_missing_values) | |
| updated_sample | No | Sample values after operation | |
| original_sample | No | Sample values before operation | |
| columns_affected | Yes | Names of columns affected |