Split Data
The Split Data building block allows you to break a value into multiple parts and save them into separate columns or variables.
How It Works
Value to split – Select the value that should be split (e.g., a full name or an address).
Separator – Define the character or text that separates the parts (e.g., a space, comma, or custom delimiter).
Positions to save – Specify which parts to extract and where to store them.
Example: Split full name to first and last name
Consider this to be your initial table:

How to set up the Split Data building block:

This is the end result after running your TaskBot:

Split from the End of Text
You can enter negative numbers in position fields to split from the end of text.
Behavior During Run
If the split value does not contain a requested position, nothing is saved for that position, and no action is taken.
Positive positions (e.g.,
1
,2
,3
) start counting from the beginning.Examples:
"Hello world", position 1 ⟶ "Hello"
"Hello world", position 2 ⟶ "world"
"Hello world", position 3 ⟶ (nothing gets saved)
Negative positions (e.g.,
-1
,-2
,-3
) allow counting from the end. (Supported from the agent version 1.1.61.)Examples:
"Hello world", position -1 ⟶ "world"
"Hello world", position -2 ⟶ "Hello"
"Hello world", position -3 ⟶ (nothing gets saved)
Position 0 is not valid and does not correspond to any value. TaskBot will generate an error if 0 is used.
Video Tutorial
Last updated
Was this helpful?