Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.databar.ai/llms.txt

Use this file to discover all available pages before exploring further.

Split Text takes a single column containing combined values and separates it into multiple columns based on a delimiter you choose. This is useful when imported data packs multiple fields into one cell.
Split Text is a transformation — it does not consume any credits.

​
How to use

1

Add a Split Text transformation

Open your table, add a new transformation column, and select Split Text to Columns.
2

Select the source column

Choose the column that contains the combined values you want to split.
3

Choose a delimiter

Pick the character that separates the values. Options include:
  • Space
  • Dash (-)
  • Comma (,)
  • Any custom character
4

Specify the number of parts

Set how many output columns you want. Excess parts beyond the limit stay in the last column.
Split text configuration with delimiter selection

​
Example

A column containing "John Doe, CEO" split by comma into 2 parts produces:
Part 1Part 2
John DoeCEO

​
Common delimiter scenarios

Original valueDelimiterResult columns
Jane SmithSpaceJane / Smith
2024-01-15Dash2024 / 01 / 15
New York, NY, 10001CommaNew York / NY / 10001
first@example.com@first / example.com

Tables overview

Learn how tables work in Databar.

Merge columns

Combine multiple columns back into one.