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?