Skip to main content
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. The delimiter field is pre-filled with " " (space) by default. Options include:
  • Space (" ")
  • Dash (-)
  • Comma (,)
  • Any custom character
To use a space as the delimiter, enter it with quotes: " ". This is already the default value when you open the configuration.
4

Specify the number of parts

Set how many output columns you want. Excess parts beyond the limit stay in the last column. The split produces a JSON value, which you can then work with further using the JSON Expander or JQ formulas.

​
Example

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

​
Common delimiter scenarios

Tables overview

Learn how tables work in Databar.

Merge columns

Combine multiple columns back into one.