Substring
Return characters from the middle of text.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
input | Name of the column(s) to edit. | string, integer, array | — | Yes |
output | Name of the output column(s). | string, array, null | null | No |
| Options | ||||
start | The position of the first character to select. If ommited will start from the beginning and length must be provided. | integer, null | null | No |
length | The length of the string to select. If ommited will select to the end of the string and start must be provided. | integer, null | null | 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 |
Examples
wrangles:
- select.substring:
input: Column
output: Result
start: 2
length: 3
| Column |
|---|
| pudding |
| Result |
|---|
| udd |
wrangles:
- select.substring:
input: Column
output: Result
start: 2
| Column |
|---|
| pudding |
| Result |
|---|
| udding |
wrangles:
- select.substring:
input: Column
output: Result
length: 3
| Column |
|---|
| pudding |
| Result |
|---|
| pud |
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 60 |
| Catalog key | select.substring |
| Recipe key | select.substring |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | select |
| Documentation group | select |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.select.substring |
| Legacy UUID | 8befddf8-602e-4fa9-8f16-4c547210ebec |
Sources