MCP ServerSplit 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.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 is a transformation. It does not consume any credits.
How to use
Add a Split Text transformation
Open your table, add a new transformation column, and select Split Text to Columns.
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.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:
| Part 1 | Part 2 |
|---|---|
| John Doe | CEO |
Common delimiter scenarios
| Original value | Delimiter | Result columns |
|---|---|---|
Jane Smith | Space | Jane / Smith |
2024-01-15 | Dash | 2024 / 01 / 15 |
New York, NY, 10001 | Comma | New York / NY / 10001 |
first@example.com | @ | first / example.com |
Related
Tables overview
Learn how tables work in Databar.
Merge columns
Combine multiple columns back into one.