Split Text Column

Take a string and split it up into an array.

The Split Text column splits up text by a value of your choosing. For example, say you have a list of people separated by commas.

Marie RaoTamsin WoodwardAlan EijkFo LambertChristina WallaceRyan Holbert

Because this value lives in a single cell, Glide sees it as a single value. However, you can split it up by the commas.

Splitting a list by commas.

When you do this, you end up with a new column with multiple values.

New values from splitting text.

The image below has created a Relation column with the Joined List column that relates all employees who are attending this meeting.

Split text with a relations column.

Because Split Text is splitting up multiple distinct pieces of information, the column you apply this to should have multiple values in each row—otherwise known as a string.

Adding and Configuring a Split Text Column

  1. In the Data Editor, open the table you want to edit.

  2. Add a new column by clicking the plus (+) symbol to the right of the table.

    • New columns added with the plus button will always appear on the right. If you'd like to add a column somewhere else in your data, you can select the dropdown menu on an existing column and choose Add column right. You can also click and drag columns to rearrange them.

  3. Give the column a name.

  4. For Type, search for Split Text or navigate to Computed → Split Text.

  5. Choose the column that contains the text you want to split, and then type in the item in that column to act as the separator. This could be one of many possible options, including a comma, period, space, hyphen, etc. depending on the value in the column.

Have a question about Split Text Column? Ask the Glide community.

Updated more than a week ago
Was this article helpful?