TextSplit
Breaks a piece of text into parts wherever a separator appears: a dash, a comma, or any other characters you choose. The output is the list of parts, in order. To split an entire table column into new columns in one step, use SplitColumn instead; Text Split works on a single text value inside a pipeline.
Inputs
| Input | Accepts | Required |
|---|---|---|
Text | Text | Yes |
Delimiter | Text | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Any |
Example
A cost center code reads EMEA-Sales-4200. Split on - and you get three
parts: EMEA (region), Sales (department), and 4200 (account). Those
pieces can then feed the rest of the pipeline, for instance comparing the
region part against a target or routing the account number into a lookup.