split_column
Split column values by delimiter to extract specific parts or expand into multiple columns for CSV data transformation.
Instructions
Split column values by delimiter.
Returns: ColumnOperationResult with split details
Examples: # Keep first part of split split_column(ctx, "full_name", " ", part_index=0)
# Keep last part
split_column(ctx, "email", "@", part_index=1)
# Expand into multiple columns
split_column(ctx, "address", ",", expand_to_columns=True)
# Expand with custom column names
split_column(ctx, "name", " ", expand_to_columns=True,
new_columns=["first_name", "last_name"])Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | Column name to split values in | |
| delimiter | No | String delimiter to split on | |
| part_index | Yes | Which part to keep (0-based index, None for first part) | |
| expand_to_columns | Yes | Whether to expand splits into multiple columns | |
| new_columns | Yes | Names for new columns when expanding |
Output Schema
TableJSON 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 |